Solved

Importing Comma Delimited files

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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

777 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