I am trying to im****t data from quickbooks pro. I have qodbc and can get
to
the information fine however when I create a link table, the very large
tables cause access 2007 to crash. I decided to im****t the table instead
of
creating a link table. I thought that we could just reim****t the new data
every week. The problem is that when you im****t a table that already
exists
it appends a number after the new table. I would have to delete the
existing
talbes that I am going to im****t, im****t the tables with updated data and
then recreate the relation****ps in the new tables. Is there a way around
this?
I'd like to just reim****t the data into the same table so that the office
people that dont' know about relation****ps dont' have to worry about
recreating that stuff everytime. Any suggestions?
Thanks.
