How make fields into records

  • Thread starter Thread starter Adker
  • Start date Start date
A

Adker

I'm importing a series of large notepad files which consist of ; separated
email fields. When I import themIget one big long record with the number of
fields equal to the number of email address fields. Thats OK but how to I
create a single record for each field? Or is there a better way to do this?
 
Open the text files in a text editor of your choice, find semicolons and
replace with a Carriage Return / Line Feed pair.

Import the file.

MH
 
Does this work for commas too?

JHL

MH said:
Open the text files in a text editor of your choice, find semicolons and
replace with a Carriage Return / Line Feed pair.

Import the file.

MH
Click to expand...
 
Thanks very much. JHL, I used the replace function in Word 2003 and it was
perfect.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Double quotes within text cause unparsable record error 2
Access Automatically Send a notification email once a record is added 0
problems importing a Paradox file into Access 2003 4
Import txt file - records on multiple lines 1
Importing Text Files Into Access 1
can you conditionally import data into Access 3
How can I import non-delimited text file into access 3
Import fields from .csv with variable column structure 4

Back
Top