Import csv file and data begins on line 4

M

Mel

hi,

I have a csv file where the data begins on line 4. I have having a hard
time trying to figure out how to use the transfertext macro to help. Can
anyone help?

Thanks,

Mel
 
K

Ken Snell [MVP]

Can you import the entire text file into a temporary table and then use an
append query to copy the "real" data to the permanent table?
 
J

John Nurick

Hi Mel,

See my message in the recent thread in this group, "Ignoring header when
importing text files to access".
 
Top