Importing Comma Delimited files

I am trying to create a database by importing a comma delimited file which has 1400 variables. Since Access will only accept 255 how can I accomplish this? What are my options? Send me an email and I will send you an example of the file that I am trying to import. wowproductions@hotmail.com
pantonerAsked:
Who is Participating?
 
cognitionConnect With a Mentor Commented:
It sounds as if you will need to create several tables, designed carefully to hold the data.

You can then create an ODBC DSN to the text file using the Microsoft Text driver.

When importing, you can then specify filter criteria, and which columns to put in each table.

So you end up with several import steps, putting different "variables" into different tables, and linking the tables by common fields or keys.
0
 
pantonerAuthor Commented:
Edited text of question
0
 
pantonerAuthor Commented:
Thanks for the answer. Can you give me a reference for creating an ODBC DSN to the text file using the Microsoft Text driver. I am not familiar with doing this at all. Where is the Microsoft Text driver? Can you recommend a book that will explain this to me?  
0
 
lamalczCommented:
I sent you an email and you responded with your attached file and  list of attributes. I am just following up in Experts Exchange to close the loop and possibly get credit.

Thanks, be looking for an email on Monday @ wowproductions.
Len
0
 
cognitionCommented:
In ODBC (which is accessed through control panel), you add a dsn, and give it a name. One of the fist option sis to select a driver, and this should be the Microsoft Text driver. You then name each of the "variables", or leave them as the default name. You can then run queries against your new data source.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.