importing csv chops first line

B

Brian Lorraine

I have a program written in access 2002/vba which takes a
delimited file (the delimiting character is "|" if it
matters) and imports it into a table. If I go to TABLES-
new->import table, select the file and all import wizard
Click to expand...
menus, it imports just fine.

However, when I use the TransferText/Import Delimted
method (either via code or macro) to import using the same
file and schema that I saved before, the very first
line/record of the file does not get imported. There is no
header line in the file. The schema does not have the
first line set as header either.
 
J

Joe Fallon

Are you setting the "hasfieldnames" parameter to False in your TrasferText
command?


I always use column headers in the first line of the file.
Try adding them and see if it works.

If it does, can you use them in future versions of the file?
 

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

Import error "The specification XML failed to validate " 4
Import errors importing Text into existing table, header vs no hea 3
Importing Data with | as the delimiter in Access 2007 3
Import fields from .csv with variable column structure 4
Odd character display (ASCII 128-159) 1
Importing Fixed Length File into Access 2007 1
Import from notepad Pipe delimited text document 1
Export Spec Problem 1

Top