Import Data from Access

  • Thread starter Thread starter toby131
  • Start date Start date
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!
 
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...
 
Back
Top