B
Bonnie
Hi,
Can anyone help me with importing a dbf? I am trying to
automate it either with a Macro or VBA code. The problem
seems to be that the original file has an index that
Access is seeing as a Primary Key and will not import
because there are duplicate values in the field. The
TransferDatabase command in a Macro works otherwise, but
I want the user to be able to do it without intervention
from me (I have to unattach the index first for the macro
to work). Any ideas? Maybe there is an easier way that
I am not aware of?? Is there a SQL command to append
from our import a different data source?
Thanks in advance.
Can anyone help me with importing a dbf? I am trying to
automate it either with a Macro or VBA code. The problem
seems to be that the original file has an index that
Access is seeing as a Primary Key and will not import
because there are duplicate values in the field. The
TransferDatabase command in a Macro works otherwise, but
I want the user to be able to do it without intervention
from me (I have to unattach the index first for the macro
to work). Any ideas? Maybe there is an easier way that
I am not aware of?? Is there a SQL command to append
from our import a different data source?
Thanks in advance.