Luke Gedeon

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 Yesterday, I mentioned that Access 2007 would not let you...
2. The Trouble With Open Source The trouble with Open Source is that you get...

Related posts brought to you by Yet Another Related Posts Plugin.