Eric,
I have little experience with ODBC connections, but I do upload
spreadsheets
and I run into the same problem. What I do is im****t the file into a
holding
table, then use a make table query with the holding table as the source
and
the table with relation****ps as the target. The query will delete the old
target and give you just the new information. I don't use relation****ps
that
much but I think they are maintained with this method.
The other way is a two step process. Append the primary key into the
target
table, using an append query. This will get a full list of all old and new
records. Then udate all the data fields with an update query. Hope this
helps.
--
Michael Conroy
Stamford, CT
"Eric" wrote:
> 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.
|
