Get Data ?

[surfdragon]

I have a spreadsheet which I update weekly from an access database table.

The table has about 25 columns of which I only need about 8.

On initial set-up all the columns are downloaded and the ones not required are deleted.

Previously excel has only downloaded the required columns on refresh. However since our system has updated to 2016 all the columns are downloaded, and the spreadsheet and formulas has to be re-configured every week.

Any ideas why this has suddenly started or how I can get around it ?
Cheers

 

[MUKESHY12390]

probably it because of Version change, does all user using same version of Excel and Access.?

I would suggest re-create Connection.

Open Excel ---Goto Data ----select Connection ---click to Add----Click Browse for More.. ----Select Access Database- and Click OK

after above steps:

click to Connection---select Name AND click to Properties-----new window will open---goto Definition tabe ---goto Command Text ---- Enter this "select ID from tblSalary"

hope it will solve the problem.

Mukesh Y

 

[surfdragon]

Thanks for that. Tried what you said and get:

Query results cannot overlap a table or XML mapping. Please select another destination?

Guess I've gone wrong somewhere????????

 

[MUKESHY12390]

Query results cannot overlap a table or XML mapping. Please select another destination?

did you try changing destination to another sheet?


why don't you first try it out in fresh workbook, just to see if it works.

 

[surfdragon]

Have tried changing the destination sheet and made a new workbook to try it.

Neither work, I guess i'm probably getting it wrong somehow!

p.s. help much appreciated