Participate!

Help bring freedom of speech and press to China, uphold the rule of law and defend human rights, by supporting the people of China in their pursuit of change in China. Click here to learn more about ways you can help.

About Me

small profile pic

I have been providing technical support to non-profits and small businesses for about 20 years.

Now as Executive Director of the Caring for China Center, I am responsible for recruiting, relationship building, fund-raising, project management, and a bunch of other things. In other words, I am not bored. :)

contact me

How to Write a Website
—
« What I Learned From Laughter  
  Project Milestone Achieved »

Using Saved Import Specifications in VBA in Access

Windows v0.0
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!

Reblog this post [with Zemanta]

Related posts:

  1. Cannot Edit Saved Import Steps in Access 2007 – Partial Workaround Yesterday, I mentioned that Access 2007 would not let...
  2. The Trouble With Open Source Image via Wikipedia The trouble with Open Source is...
  3. How to Format Your Posts Like a Pro: Simple Powerful Results I just discovered a real cool new plug-in. Guess...
  4. Never Forget 64 This video only has one section with English sub-titles,...
  5. 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.

September 2nd, 2009 | Category: For Geeks | Leave a comment

Leave a reply

CommentLuv Enabled