Import external data (from Access) brings in header rows only

gradco

New Member
Joined
Jan 21, 2009
Messages
1
Hello,

I'm trying to import a query from Access into Excel (linked). I've performed this operation with other queries in my database, but I'm having trouble with one. Every time I import it, only the header rows display, no data. Any idea on what the problem is?

Thanks,
Jay
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Andrew Fergus

MrExcel MVP
Joined
Sep 9, 2004
Messages
5,450
Office Version
  1. 365
  2. 2021
  3. 2016
Platform
  1. Windows
Hi Jay and welcome to MrExcel!

I presume you have checked the query within Access is actually returning data? And you are linking to that same query, and haven't made a typo on the name?

Also try deleting the link to the query and re-create it, see if that makes any difference. Lastly, check you haven't inadvertently set some criteria in your query in Excel.

Andrew
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,208
Messages
5,857,920
Members
431,908
Latest member
Marjie174

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top