Import Spreadsheet Data to Query

[CJ]

Hi Groupies

I have a button that exports query data to an Excel spreadsheet. My problem
is that I would like to bring the data back from Excel and back into the
original query. The data does not all reside in one table nor should it,
thus the use of a query.

My problem is that TransferSpreadsheet does not like working with queries,
only tables.

Is there a way that I can do this?

 

[pietlinden]

Hi Groupies

I have a button that exports query data to an Excel spreadsheet. My problem
is that I would like to bring the data back from Excel and back into the
original query. The data does not all reside in one table nor should it,
thus the use of a query.

My problem is that TransferSpreadsheet does not like working with queries,
only tables.

Is there a way that I can do this?

In short, no.
A query is a DESCRIPTION of a dataset, and NOT the data. If you want
to bring the data back in, you'd have to link to the spreadsheet, then
perform a series of append queries.

 

[CJ]

In short, no.
A query is a DESCRIPTION of a dataset, and NOT the data. If you want
to bring the data back in, you'd have to link to the spreadsheet, then
perform a series of append queries.

Alrighty then.

My problem is that the data needs to go to excel so that somebody, who
refuses to work with access, can manipulate the data. I would then like to
update the records in access with his changes.

I guess I need a bit of an example of how I would go about updating the
records in Access.


CJ

 

[pietlinden]

Alrighty then.

My problem is that the data needs to go to excel so that somebody, who
refuses to work with access, can manipulate the data. I would then like to
update the records in access with his changes.

I guess I need a bit of an example of how I would go about updating the
records in Access.

CJ

If you have a unique index in your Access table, you could link to the
Excel tab and then run an update query.. If you the table has child
records things could get ugly. Otherwise, you could just delete the
contents of the table, and reimport the contents of the spreadsheet.
Heinous, but...

 

[Guest]

If you have a unique index in your Access table, you could link to the
Excel tab and then run an update query.. If you the table has child
records things could get ugly. Otherwise, you could just delete the
contents of the table, and reimport the contents of the spreadsheet.
Heinous, but...

Well, the reason I wanted to use the query was because of the number of
tables involved................so, I guess I get to tell him to "Deal with it
!" ....can't wait ;-)

The data from Excel can be copied and pasted into the Access query but that
just seems so archaic. Automation would be so much better.

Anyway, thanks for the input!

Cheers

CJ