import dbf into access

can anyone know how to import dbf file into access by selecting some of the
field

re: import dbf into access

Good chance I'm just plain ignorant, but the only way I could do it
(doesn't mean it's the only way) was to link to the DBF file and then
create an append/maketable query to get just the fields I wanted and
then to run it. That's ONE way... did you need to process a whole lot
of these?

re: import dbf into access

>can anyone know how to import dbf file into access by selecting some of the[color=blue]
>field[/color]

If you go through the regular import process (File/Get External Data/Import)
you get a little wizard that walks you through the process; you can specify
which fields to import and what type they are, etc.

HTH

Jan
Jan Stempel
Stempel Consulting

re: import dbf into access

Janross wrote:[color=blue][color=green]
> >can anyone know how to import dbf file into access by selecting some[/color][/color]
of the[color=blue][color=green]
> >field[/color]
>
> If you go through the regular import process (File/Get External[/color]
Data/Import)[color=blue]
> you get a little wizard that walks you through the process; you can[/color]
specify[color=blue]
> which fields to import and what type they are, etc.
>
> HTH
>
> Jan
> Jan Stempel
> Stempel Consulting[/color]

<INSERT Homer Simpson doing the "duh...!"> Yes, and then create the
import spec and save it and you're good to go in the future...
"S-M-R-T, I am so smart!" <accidentally setting fire to freshly
earned/printed/minted diploma>