Text File Import

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: RShrader (rshrader_at_hotmail.com)
Date: 12/20/04 

Date: Mon, 20 Dec 2004 03:49:19 GMT

Hi,

I have a text file that contains data that I want to import into my MS
Access database. The layout of this text file contains a number and 5
pieces of data for that number as in the example below.

12345;data1;data2;data3;data4;data5

I would like the data to be imported into my MS Acces table in the
following format.

12345 data1
12345 data2
12345 data3
12345 data4
12345 data5

In this example, the unique number has as many records as there is
data (that's seperated by the delimiter).

Any help or a point in the right direction to any web resources
dealing with this type of importing would be helpful.

Thanks in advance.

rshrader@hotmail.com

Relevant Pages

  • Re: Should be simple
    ... reporting system" and "get the information from Access onto my report"... ... You mention importing data ... If your application only imports Excel data directly, ... I should have mentioned that this was an Access database. ...
    (microsoft.public.access.formscoding)
  • Re: Compile, Crash, Scream
    ... There are a variety of things that can cause an Access database to bloat in ... always compact/repair so it wasn't that I hadn't been compacting. ... > Now I'm wondering if there's some benefit to occasionally importing a ...
    (microsoft.public.access.formscoding)
  • RE: Criteria for importing tables from a odbc link
    ... Importing the data from the linked tables is a bad idea for several reasons. ... You did not say what the back end database engine is. ... If it is an Access database, it would be faster to do a direct ... month in order to run a report. ...
    (microsoft.public.access.externaldata)
  • Extraction of a certain field from text files
    ... I have this access database which consists of 6 different ... The data in the 6 tables come from importing of data from 6 different ...
    (microsoft.public.access.tablesdbdesign)
  • Extraction of a certain field from text files
    ... I have this access database which consists of 6 different ... The data in the 6 tables come from importing of data from 6 different ...
    (microsoft.public.access.tablesdbdesign)