excel import code

[dekutoski]

I need an import code to copy the values of an above row in Excel when the row is empty. Please somebody help! There is no primary key to update after the import.

 

[SkipVought]

I did notice that SOME of the TIME columns were converted to NUMBERS. Those columns, just format as TIME.

On the other columns that did not convert...

Select the time text in those FOUR columns

Edit > Replace - put One SPACE in the FIND textbox and NOTHING in the other, and hit Replace ALL.

In Edit > Replace put
[tt]
a in the FIND textbox and
AM
^
|
SPACE
[/tt]
in the other, and hit Replace ALL. That's SPACE and then AM.

[tt]
p in the FIND textbox and
PM[/highlight]
^
|
SPACE
[/tt]
in the other, and hit Replace ALL. That's SPACE and then PM.


Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[weirdcpu]

Hello,

Sorry to ask but if you never have code anything in Excell why don't you start by taking a tutorial about excel macro coding ?

No critic implied i just try to understand your need and why you want to go so fast ? ( sometime i had to help technician who have this kind of reaction : code first , problem solving first ... )