Importing CSV data

[neileg]

I should know this, but I don't!

I want to import a list of names into a single field table. The text file looks like this:

Appleby David, Atkinson Susan, Blair Brenda, Brown Karen

So each record is terminated by a comma and a space. The import wizard expects records to be separated by a carriage return.

Obviously I can massage the data by replacing the comma and space with a CR, but surely I should be able to import the file as it stands?

 

[crosmill]

Can i suggest you put it into excel where you can copy, paste special then transpose it......

Probably the easiest way as long as it's not too big.

 

[crosmill]

or you could import it and declare a comma as the line seperator, that'd probably be easier still!!

 

[dcx693]

or you could import it and declare a comma as the line seperator

. Well, that's a neat trick. Where did you see that option?

neileg, I would just write a quick DAO program to parse out the data. Or use the Excel Text to Columns command can do it, then transpose it and import it into Access.

 

[neileg]

crosmill, as dcx693 points out, it should be as easy as that, but it ain't.

As for using Excel, I find Word easier to use a find and replace.

Well, at least I haven't gone mad and missed something obvious!

 

[crosmill]

quoter you could import it and declare a comma as the line seperator

My appologies thats an option you get in SQL Server. Sorry.

As for using Excel, I find Word easier to use a find and replace.

I didn't say find and replace, I said Copy and paste Sepecial then transpose it. It would list all the names like this

Appleby David
Atkinson Susan
Blair Brenda
Brown Karen

Which would then import nicely into a single field in Access.