Solved

Importing Comma Delimited files

Posted on 1999-01-12
5
301 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 100 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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

757 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now