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.