Importing text file

[Fredrated]

I would like to import a fixed-width text file into an all-text table.
I already have a table with the correct text field sizes, but of course when
I run the Get External Data>import function, I am presented with a field
list, with field types and sizes which represents Access's best guess as to
what the table structure is.
This is useless to me, and my table has almost 100 fields, so it is quite
tedious to go through the list and correct the types and sizes.

What I would like to do is just have access import the text data based on
the table structure of the existing table, cutting up the text data to fit
the fields in the existing table. Is there any way to do this?

Thanks in advance for any help.

Fred

 

[Jeanette Cunningham]

Hi Fredrated,

import into a new table, then use append queries to move the data from the
new table to your existing table.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia