Import csv file and data begins on line 4

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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?
 
Hi Mel,

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