Importing text

  • Thread starter Thread starter bdavis
  • Start date Start date
B

bdavis

Hello,

I've been importing some large text files out of an
accounting system. For some reason, I cannot get Access
to recognize to first row of data as column headers. Any
Ideas?
 
bdavis said:
Hello,

I've been importing some large text files out of an
accounting system. For some reason, I cannot get Access
to recognize to first row of data as column headers. Any
Ideas?
Click to expand...
There is a switch in the import wizard that allows the first row to be seen
as field names.
If that won't work then you will have to run a query or manually delete the
row.
 
What I have done (when receiving, say monthly text files) with the same
structure, is to identify records that does not comform to a real data
record (numeric value on the first five first characters, for example) and
discard the lines as invalid. That way I only import those lines of real
data into the Access table.
If you trying to identify the header, you will have to make a routine to
figure out the field names in VBA, then use these to build the table.
 
Back
Top