Importing Data from a .tab file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a .tab file with data from FileMaker Pro and would like to import it into my current Access table. How can I choose which field from the .tab file corresponds to the appropriate field in the Access table. There are more fields in the Access database than what came in the .tab file and they're in a different order

thanks
 
Iimport the file into a temporary table, then use an append query to copy
the data into your permanent table.

--
Ken Snell
<MS ACCESS MVP>

SteffiMom said:
I have a .tab file with data from FileMaker Pro and would like to import
Click to expand...
it into my current Access table. How can I choose which field from the .tab
file corresponds to the appropriate field in the Access table. There are
more fields in the Access database than what came in the .tab file and
they're in a different order.
 
that's for that response ~ I was able to do an append query but when I executed it, the new records (from FileMaker Pro) didn't go into the access table. I got a "validation rule violation" error message ~ but can't find it in Help

Thanks....agai

----- Ken Snell wrote: ----

Iimport the file into a temporary table, then use an append query to cop
the data into your permanent table

--
Ken Snel
<MS ACCESS MVP

SteffiMom said:
I have a .tab file with data from FileMaker Pro and would like to impor
Click to expand...
it into my current Access table. How can I choose which field from the .ta
file corresponds to the appropriate field in the Access table. There ar
more fields in the Access database than what came in the .tab file an
they're in a different order
 
Validation rule message means that something in the data that you're
appending to the table does not match the format or the validation rule of
the field into which you're trying to append it (for example, if the
original data is an empty string and the field into which you're trying to
append it has the "Allow Zero Length" property set to No; or if you have a
validation rule on the field that says ">25" and the value that you're
trying to append has a value of 10; etc.).

--
Ken Snell
<MS ACCESS MVP>

steffimom said:
that's for that response ~ I was able to do an append query but when I
Click to expand...
executed it, the new records (from FileMaker Pro) didn't go into the access
table. I got a "validation rule violation" error message ~ but can't find
it in Help.
 
Back
Top