source database property on a query

[Guest]

I don't know how to set the source property on a query. I don't have access
to the Access db yet but I have an excel spreadsheet that I would like to
populate my db so I can test the query. I imported the Excel spreadsheet that
comes from the access db to a table called porthistory. I tried setting the
source property which says (current) to [tables.porthistory] on the query
just to get some data in it says the name is invalid.

That brings up a question how do you set the source property so the query
would work on a table or how do I set it to get to the Access db I want to
eventually use?

 

[Guest]

i will repost this question in access general

 

[Marshall Barton]

I don't know how to set the source property on a query. I don't have access
to the Access db yet but I have an excel spreadsheet that I would like to
populate my db so I can test the query. I imported the Excel spreadsheet that
comes from the access db to a table called porthistory. I tried setting the
source property which says (current) to [tables.porthistory] on the query
just to get some data in it says the name is invalid.

That brings up a question how do you set the source property so the query
would work on a table or how do I set it to get to the Access db I want to
eventually use?

The SourceDatabase "property" in a query's design view
becomes the IN phrase in the FROM claues. In other words,
just use the full path to the other database file. It is
used as an alternative to linking to a table in another
database, workbook, or whatever.

Note that you can not modify data in an Excel spreadsheet by
editing the data in the query. You can modify the data in
your imported copy of the data, but if you want those
changes to appear in the spreadsheet, then the changes
should be made in the spreadsheet and then reimported into
Access.

If your table is local or linked, don't set the property.