Importing text file

W

Waleed

Hi,
I need a code to import text file which includes more than 800 fields
(Columns) in to access tables.
Thanks a lot
 
S

Steve Huff

Access tables are limited to 255 fields so as you may or may not know you
will need to write code that imports it into muliple tables.

What format is the text file in? If it's in somehting Excel would recognize
you could split the fields up and create seperate files and use the import
wizard in Access.

Just some thoughts.
 
W

Waleed

Yes I was asking about the code which can import this big file into multiple
tables, if you can help me in this please.

thanks
 
Top