Data from Linked Excel not showing

A

Alain

Hi to all,

not sure if this is the right group to post this but here it is. I have an
Excel spreadsheet that use a web query to get daily updated currency rates.
Instead of transferring the data from the Excel to Access table, I decide to
link Excel to Access and work my queries from there, (reading only)

The spreadsheet has 4 col only, ID, CurrName, CAD, InCAD, columns 2-3-4 are
updated daily, coded from Access, works beautifully
My problem is once the spreadsheet is linked, no problem to link and on the
wizard, I see values in all columns. Once I open the linked file, I see data
in col 1 and 2, but not 3 and 4,
Can anyone explain why it is like that before I go too far and realize that
it simply cannot be done.

Thanks
Al
 

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

Manipulating Excel via Access 3
Open-Edit-Close a Linked Excel File from Access VBA code 1
How to get Access to recognize revised linked table content? 4
Check linked table connection 1
Editing a Linked Spreadsheet 1
Numeric Field Overflow Problem 3
Return Control to Access after Excel manipulation 3
linked Excel file 3

Top