Importing text file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I need a code to import text file which includes more than 800 fields
(Columns) in to access tables.
Thanks a lot
 
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.
 
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
 
You must log in or register to reply here.

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

Importing Text Files Into Access 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Best Tool to Repair Corrupted PDF Files 0
Error while import Excel file to Access 6
An error occurred trying to import file 'c:\temp\import.txt'. The file was not imported. 0
Easy Steps to Import PST Files to Office 365 0
Import problem into SQL Server 2005 linked table 1
Importing a text file - choosing where the fields end up 1

Back
Top