How to link table from SQL Server to ms access

[blyssz]

I have a table in MS access that I want to link to SQL Server 2005 for reporting purposes. How do I do that???

Thanks,
Blyssz

 

[bburnell]

The best way to do it is to convert to a SQL Database. Try these links:

http://www.microsoft.com/Sqlserver/2005/en/us/migration.aspx

http://support.microsoft.com/kb/237980

Brett

--------------------------
Web/.net Programmer & DBA
Central PA

 

[blyssz]

Thanks bburnell,

I have another question related to the above question.
If we migrate an MS access table using SSMA which is linked to a table in another database, will the table in SQL Server database after migration be the linked table or just an independent exported table?

Thanks,
Blyssz

 

[bburnell]

That's a good question. I *think* you can make it either way. Don't quote me on that.

--------------------------
Web/.net Programmer & DBA
Central PA