Import Data from Access

T

toby131

I am importing an access query into an excel spreadsheet. The query has
about 30 fields that work fine. I added a calculated field to the query and
refreshed the data in excel. The field name shows up, but all the records
are blank. In access the field is working fine. Any suggestions on how to
troubleshot this problem? Thanks!
 
T

toby131

The calculation is in the Access Query.

smartin said:
Do you mean you added a calculated field in the Access query itself, or
you added a column with a calculation in the worksheet?

If the former, where is the calculation? In MSQuery or in Access?
.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing from Access 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
No Results returned from Access query 3
Exporting data to Excel pivot table from Access 3
Access Creating names from fields in access database. 0
Import Data from Access query 8
Pivot Table Fields 1
Access Subscript out of range when importing into access 2010 from excel 0

Top