Advance Import of Data

[rwiethorn]

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]

Re: Advance Import of Data

rwiethorn wrote:

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