Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Import odd text file into Access 2k
Name: jneufeld Date: April 22, 2003 at 14:04:16 Pacific 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?
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...
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...
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 ...
Files Already Open
