Importing .csv data each as an Individual Record

[manix]

Man I thought this would be simple, but it quite clearly isn't!

I have a .csv file that contains around 250 email addresses. I simply want to import these into an Access table, each email creating a new record!

NO using the import function only seems to allow you to import data as long as each separate piece of data is on field in a record! I understand whent this might be the case, but why the hell can I not import it so each piece of data is a separate record in the table!!!!!!!!!!!

Please note I understand some sort of complex query may do it, but I am not that experienced with that yet and so don't know how it's done!

Please can anyone offer a simple solution? From where I am sitting, there does not appear to be one!!!!

Thanks.

 

[boblarson]

So are you saying that within your csv file you have something like this:

xx@myemail.com,jdow@hisemail.com,dwilfsl.afik@dikd.net,

and you want to import it in as just a single field called emailaddress (or something like that)?

 

[namliam]

It may be very easy to do with some VBA coding.... if you are up for that...

Post a peace of your file (or make up a bit that looks like it to prevent spammers from finding email addresses online)

 

[The_Doc_Man]

Please do not double post.