Importing a .txt file

[Guest]

I'm importing a .txt file with data in three columns. However, because the
first 30 rows have no data in column 3 Access won't pick up Field 3 at all!!

Does anyone know how to get around this problem?

..txt file is being imported comma delimited example below
record 1-30 00121554,R,
record 30 onwards 154515615,R,AL

 

[Arvin Meyer]

Build the table first. When you import the data, change from the default
[into a new table] to into an existing table. It will then append the
records to your table.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Allen Browne]

Use an import specification to tell Access how to import the text file.

1. Manually add a value to the first row.

2. When you do the Import (File | Get External | Import), in the next screen
of the wizard, click the Advanced button. You can create an Import Spec, and
save.

Next time you do the import, use the Import Spec, and it will grab the
values even without anything in the first few rows.

 

[Guest]

Hi Arvin,

Have you actually tried this?

It doesn't work for me. Sure the field is always there but no data has been
captured from the .txt file.

Build the table first. When you import the data, change from the default
[into a new table] to into an existing table. It will then append the
records to your table.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

I'm importing a .txt file with data in three columns. However, because the
first 30 rows have no data in column 3 Access won't pick up Field 3 at all!!

Does anyone know how to get around this problem?

.txt file is being imported comma delimited example below
record 1-30 00121554,R,
record 30 onwards 154515615,R,AL

 

[Guest]

Allen,

I'm affraid i've tried that and it doesn't work. It will bring in an
additional field but still own't lift the data from the .txt file