Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 190
  • Last Modified:

Link a Comma Separated file to an Access Mdb using VB

Hi There

I am looking for the code to link an external Text file to an Access mdb. The TEXT file is comma delimited.
1 Solution
Access can actually directly link delimited TXT files without any extra step:

In the Tables view rigth click and select "Link Tables..."
Then a Link Dialog appears look for "File Type:" and  select "Text File" and select your file.
Another dialog appears, foolow the instructions and that's all


Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now