Import csv file and data begins on line 4

[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

 

[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?

 

[John Nurick]

Hi Mel,

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