Hi all,

I am making one project in which i want to give the facility of importing database data from text file to MS-Access database.
I know about importing data from excel to access but i am facing problem while importing data from txt file.

I try with using space as delimiter but if there is any space like between name than i am facing problem. And if i am using comma as delimiter than if there is an comman in address than i am facing problem.

so can anybody guide me and help me with by giving some code or reference sample project.
Thanks in advance.


You can use comma as a separator but you should enclose text in quotes, like this:
'One text field'