Connecting Tech Pros Worldwide Help | Site Map

Advance Import of Data

rwiethorn
Guest
 
Posts: n/a
#1: Mar 11 '08
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
Salad
Guest
 
Posts: n/a
#2: Mar 11 '08

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