| Computing.Net: Over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to sign up now, it's free! |
Import odd text file into Access 2k
|
Original Message
|
Name: jneufeld
Date: April 22, 2003 at 14:04:16 Pacific
Subject: Import odd text file into Access 2k
OS: Windows 2000
CPU/Ram: P4 1.1/256MB
|
Comment: I'm looking for a neat way to import an odd text file into Access 2000. The text file is a list of fixed width records and Access has no trouble importing it. The problem is that the file contains multiple records per client, in order by client, but only prints the ClientID in the first record. The next few records refer to the same client, but the ClientID field is empty. I need to carry the ClientID value down to the following records until the a record is encountered that has a ClientID already (this indicates the beginning of the next client's records). Any suggestions?
Report Offensive Message For Removal
|
Post Locked
This post is quite old and has been locked from receiving new replies. Please create a new posting instead.
Go to Office Software Forum Home
Results for: Import odd text file into Access 2k
Importing text in Access 2003 Summary: I'm trying to import a large text file into Access. The data is separated with commas, but there are no line breaks. Each line just runs together. When I use the import wizard in Access, it puts ev...
www.computing.net/answers/office/importing-text-in-access-2003/6279.html
cannot import .xls file into Access Summary: i want to import an excel 2003 spreadsheet into access 2003. i know the correct procedure to do this: File/GetExternalData/Import and i choose the location that i want to import the .xls file from. we...
www.computing.net/answers/office/cannot-import-xls-file-into-access/1005.html
Text file to Access help Summary: Hi, I am having a problem with a text file that I am trying to import into Access. The file is on a CD from one of our vendors that we load into a mainframe. I am trying to take this data and put it ...
www.computing.net/answers/office/text-file-to-access-help/499.html
