Bringing in External data from Ms-Access - Excel 2016

[EricC99]

Help ... I am using external date to bring in data from fields in an Ms-Access table

I set the link up and everything went smoothly. i imported data and was able to refresh it when the data changed in the Access table

But then I added 2 extra fields to the table in Access. Whatever I do, I cannot get those 2 extra fields to come into the spreadsheet. (even if I set up a completely fresh spreadsheet)

Please can anybody tell me what I need to do to get Excel to "see" the 2 new fields? How do I get to edit the query to tell Excel I need the 2 extra fields?

Tearing hair out - please can anybody help?

EricC99

[alansidman]

What is the SQL statement in Access for the Query you are trying to bring into Excel. It is possible that you may be using some functions in Access that Excel does not recognize.

[EricC99]

It is a table that I am trying to import.

The 2 fields causing the problem are integer format, between 1 and 84 ...
|And you might have just helped me to solve the problem ...
brb

[EricC99]

yes indeed.

The problem was the format of the data in the table in Access
I had ASSUMED that the two new fields were integer format, but they weren't.
They were actually in binary format, so Excel just saw a whole load of nonsense coming down the pipe and decided not to play!
The table was being populated by a "maketable" query in Access. I have now converted it to an append query, and those fields are now defined as integer format. problem solved

Many thanks for your help. It is greatly appreciated.

EricC99

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.