Solved

Importing Comma Delimited files

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
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…

828 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