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.
Importing text in Access 2003
Name: tclark333 Date: October 24, 2006 at 11:58:51 Pacific OS: XP CPU/Ram: na Product: na
Comment:
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 everything on one line. I think each field is the same length, so might there be a way to tell it to make a new line after so many characters?
Name: Jennifer SUMN Date: October 24, 2006 at 15:27:31 Pacific
Reply:
Are you selecting "Text Files" as the import filetype? If the file is a csv file, then the comma is the field separater.
Life is more painless for those who are brainless.
0
Response Number 2
Name: tclark333 Date: October 25, 2006 at 04:29:12 Pacific
Reply:
Yes, I have been selecting text file as the import file type.
0
Response Number 3
Name: Jennifer SUMN Date: October 25, 2006 at 05:37:40 Pacific
Reply:
Is the file a txt file or a csv file?
Life is more painless for those who are brainless.
0
Response Number 4
Name: tclark333 Date: October 31, 2006 at 08:40:46 Pacific
Reply:
It was a text file (.txt). I have since got around this problem. It looked like there were the same amount of commas in each line, so I wrote a small program to read through the entire file, counting the commas along the way. Each time it read the amount of commas that were supposed to be in a line, it would insert a carriage return there.
This wasn't the most efficient solution, as it took about 30-45 minutes to read through the ~7000 pages in Word, but it worked in the end!
Summary: I am trying to import a .txt file to Access 2003 with 3 row headers. How do I remove the headers after the page break and import columns based on what row it lines up on. I was thinking maybe there i...
Summary: This is an Access db to track leave slips. To enter new time we have a form with a combo box, choose a name in the combo box, then a subform shows that employee's info from our timeoff table, and lets...
0 
