0

Greetings all. Its been some years since I did anything in QB.

I need to manipulate a txt file so it can be imported into MSAccess.

Problem:
The file is already comma delimitted, however each line of text contains multiple records.

I need to insert a <return> after every 35 commas (fields), before I can import the data into MSAccess.

The txt file is rather large (>20 megs) and manually inserting a <return> when needed is not an option.

Any assistance is appreciated!
Moe

3
Contributors
2
Replies
3
Views
11 Years
Discussion Span
Last Post by WaltP
0

Try http://zamzar.com

Once you select the file from your hard drive the combo box beside it will contain an option "mdb" to convert it to an Access database. You need to enter your email in Column 3 and they will send the result to you.

I need to manipulate a txt file so it can be imported into MSAccess.
Problem:
The file is already comma delimitted, however each line of text contains multiple records.
I need to insert a <return> after every 35 commas (fields), before I can import the data into MSAccess.
The txt file is rather large (>20 megs) and manually inserting a <return> when needed is not an option.

0

Greetings all. Its been some years since I did anything in QB.

I need to manipulate a txt file so it can be imported into MSAccess.

Problem:
The file is already comma delimitted, however each line of text contains multiple records.

I need to insert a <return> after every 35 commas (fields), before I can import the data into MSAccess.

The txt file is rather large (>20 megs) and manually inserting a <return> when needed is not an option.

Any assistance is appreciated!
Moe

Read a character at a time. Write that character to a new file. Count every comma and at 35 output a <return> instead of the comma.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.