Export 1000 first records from all tables in an SQL Server database to MS Access
Posted on 2005-03-08
I need a way to take an extract of a huge SQL Server database offline.
I think the best way is to automaticly export, by a script maybe, the 1000 first records of every table to Access. Then I'll be able to copy this small Access database to my computer, then recreate a small
SQL server database on my computer. This will allow me to test my programs against an offline version
of the huge original SQL server database. By the way, I need to do the same for other ODBC data sources,
like AS400, Oracle, etc.
Thanks in advance.