Hi
I am trying the import data into excel (using excel data menu) from a table/query I have made in Access so I can then use a little macro to refresh it automatically. But I am having challenges...
This works with other tables but not the ones I have built, anyone know what I am doing wrong?
Im doing the following:
In excel: Data>Import External Data>New Database Query>Select New Data Source, click OK>1.Enter a name>2.select "Driver Do Microsoft Access[*.mdb]">3.Connect to the database/table, click OK>4.select a default table,click OK>then OK again>In the next screen "Query Wizard - Choose Columns" I can see the name of the table/query but in the +/- drop down there are no column names to select??
Does anyone know why it is not pulling through the column names? What might I be doing wrong here?
Any help will be greatly appreciated as I have already spent hours trawling the web and testing.
Many thanks
Cross-post here: http://www.mrexcel.com/forum/showthread.php?t=486877
I am trying the import data into excel (using excel data menu) from a table/query I have made in Access so I can then use a little macro to refresh it automatically. But I am having challenges...
This works with other tables but not the ones I have built, anyone know what I am doing wrong?
Im doing the following:
In excel: Data>Import External Data>New Database Query>Select New Data Source, click OK>1.Enter a name>2.select "Driver Do Microsoft Access[*.mdb]">3.Connect to the database/table, click OK>4.select a default table,click OK>then OK again>In the next screen "Query Wizard - Choose Columns" I can see the name of the table/query but in the +/- drop down there are no column names to select??
Does anyone know why it is not pulling through the column names? What might I be doing wrong here?
Any help will be greatly appreciated as I have already spent hours trawling the web and testing.
Many thanks
Cross-post here: http://www.mrexcel.com/forum/showthread.php?t=486877
Last edited by a moderator:
