Using Saved Import Specifications in VBA in Access

- Image by . SantiMB . via Flickr
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:
- Cannot Edit Saved Import Steps in Access 2007 – Partial Workaround Yesterday, I mentioned that Access 2007 would not let...
- The Trouble With Open Source Image via Wikipedia The trouble with Open Source is...
- How to Format Your Posts Like a Pro: Simple Powerful Results I just discovered a real cool new plug-in. Guess...
- Never Forget 64 This video only has one section with English sub-titles,...
- Is it really Web 3.0 or just 2.5? Web 2.0 has been described both by the technology...
Related posts brought to you by Yet Another Related Posts Plugin.



![Reblog this post [with Zemanta]](http://img.zemanta.com/reblog_e.png?x-id=2c115176-b2d0-4189-8bf7-cbc24e070964)
Recent Comments