Converting to Jet table from SQL Server Linked table

  • Thread starter Thread starter Guest
  • Start date Start date
rmcompute said:
Is there an easy way to convert a table linked to SQL Server to a Jet
database ?
Click to expand...

Delete the link and then import the table.

File - Get External Data - Import
 
It might be easier to use Enterprise Manager's DTS function to export the
tables to Microsoft Access MDB. I'm sure that's how I would do it.

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
| Is there an easy way to convert a table linked to SQL Server to a Jet
| database ?
 
Back
Top