import dbf into access

[Ong]

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

[pietlinden]

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?

[Janross]

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

field

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

[pietlinden]

Janross wrote:

can anyone know how to import dbf file into access by selecting some of thefield
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

<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>