?
Solved

Importing Comma Delimited files

Posted on 1999-01-12
5
Medium Priority
?
312 Views
Last Modified: 2012-05-04
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
0
Comment
Question by:pantoner
  • 2
  • 2
5 Comments
 

Author Comment

by:pantoner
ID: 1973264
Edited text of question
0
 
LVL 3

Accepted Solution

by:
cognition earned 300 total points
ID: 1973265
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
 

Author Comment

by:pantoner
ID: 1973266
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
 

Expert Comment

by:lamalcz
ID: 1973267
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
 
LVL 3

Expert Comment

by:cognition
ID: 1973268
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question