Is there a utility to import all tables from a SQL Server database to an empty Access database?
The Access database has previously been upsized to SQL Server but there's now a requirement to do the reverse.
import from SQL Server tables to Access database
-
- 5StarLounger
- Posts: 1148
- Joined: 08 Feb 2010, 21:27
-
- 3StarLounger
- Posts: 287
- Joined: 09 Mar 2010, 23:16
- Location: Canberra Australia
Re: import from SQL Server tables to Access database
Get External Data...Import will do it, but it is not a reverse downsize..just an import.
You do not have the required permissions to view the files attached to this post.
Regards
John
John
-
- 5StarLounger
- Posts: 1148
- Joined: 08 Feb 2010, 21:27
Re: import from SQL Server tables to Access database
I had tried that before and got the wrong set of tables, must have been an incorrect SQL Server database as it's worked now. Thanks any way John