Member Avatar for guest11

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.

Regards
Guest11

  • 2 Contributors
  • 1 Reply
  • 103 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by Teme64
Member Avatar for Teme64

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.