Linking to different sources of data in Access 2003.

J

Joao de Souza

I'm putting together a small reporting database, that takes data from
both an SQL server other access databases, and excel tables. How can I
link to these different data sources at the same time? If I use the
regular table link function on a .MBD file, I cannot link to the SQL
server. And when I use a .MDP access project, I can link to the SQL
server, but cannot import the access and excel files (and I don't want
to have them added to the SQL database). Any ideas on how I should do this.

And incidentally, I don't know if it makes any difference or not, but I
won't need to enter any data into the table. This is just a reporting tool.

Cheers.
 
J

John Nurick

Hi Joao,

Set up an ODBC connection to the SQL server using the Data Sources
applet in the control panel. You should then be able to use it as a data
source for linked tables in an .mdb.
 

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

access does not display odbc sources when selected 2
ODBC Data errors in Access 2007 1
link odbc from multiple sources 1
What does linking a Access table to an SQL table mean? 2
disappearing data sources dialog box 1
How do I not allow updates when linking 6
#DELETE in all fields after linking to SQL Server table 1
Cannot link to SQL server 17

Top