Using Saved Import Specifications in VBA in Access

I was about to thank Allen Browne over at PC Review for his excellent solution, when I discovered that I had to sign-up for yet another online account in order to comment there.

Oh well, it is easier to post on my own blog anyway.

So here is how it works.

You import your data manually and just before finishing go into advanced mode and save your import specification. Then the next time you want to repeat the import use the DoCmd.TransferText method and reference your saved import specification.

Yep, it’s that easy!

Related posts:

1. Cannot Edit Saved Import Steps in Access 2007 – Partial Workaround
2. The Trouble With Open Source
3. How to Format Your Posts Like a Pro: Simple Powerful Results
4. Is it really Web 3.0 or just 2.5?
5. GTD System