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".
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing what file name? 3
Import fields from .csv with variable column structure 4
TransferText "Unparsable Record" error 2
Csv import: direct link vs temp table dump 2
import csv truncation 1
Importing Delimited files 5
Limitation with transfertext to csv file? 5
CSV Import Error 2

Back
Top