Converting to Jet table from SQL Server Linked table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there an easy way to convert a table linked to SQL Server to a Jet
database ?
 
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 ?
 
You must log in or register to reply here.

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

Coverting linked tables into local tables 2
Link from SQL server 1
What are the steps to fix damaged MDF files in SQL Server? 0
linking to SQL Server db table 6
query links to SQL server and mdb table 1
Index with SQL Server Linked Tables 1
Pass Through Queries (Access 2002) 2
Convert from Access97 to 2003 with jet engine 1

Back
Top