Connecting Tech Pros Worldwide Help | Site Map

Advance Import of Data

  #1  
Old March 11th, 2008, 02:45 PM
rwiethorn
Guest
 
Posts: n/a
Hi all,
It's been a while since I used MS Access.
I remember a way of importing data (ie csv, or tab delimited) and
formatting the data (ie specify data types, columns to skip, ect),
then saving that Import Spec.

Then later in code you can reference that Import Spec.

I cannot seem to save/create an Import Spec in MS Access 2002. Can
someone point me into right direction?

Thanks,
rwiethorn
  #2  
Old March 11th, 2008, 02:55 PM
Salad
Guest
 
Posts: n/a

re: Advance Import of Data


rwiethorn wrote:
Quote:
Hi all,
It's been a while since I used MS Access.
I remember a way of importing data (ie csv, or tab delimited) and
formatting the data (ie specify data types, columns to skip, ect),
then saving that Import Spec.
>
Then later in code you can reference that Import Spec.
>
I cannot seem to save/create an Import Spec in MS Access 2002. Can
someone point me into right direction?
>
Thanks,
rwiethorn
Did you hit the Advanced button after you selected the file to import?

Bugs
http://www.youtube.com/watch?v=-zc2908P7bs
Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
Settings for autovacuum for batch uploading of data? Carlos answers 3 November 23rd, 2005 12:53 AM
How to export a subset of data from a dataset. David Richards answers 2 November 21st, 2005 08:45 PM
Automate import of data from several text files Phil Latio answers 2 November 13th, 2005 12:54 PM
importing data from customer workstation Alexander Pope answers 1 November 12th, 2005 06:27 AM