[thelist] Copying tables
Scott Dexter
sgd at ti3.com
Wed Oct 25 11:40:24 CDT 2000
> I know this is a FAQ but I can't find the answer. I have an
> Access database
> with about 50,000 records. I have another table in the same
> database with
> the same structure that is linked to a SQL server database.
> I need to move
> all of the records from the Access table to the SQL Server
> table. Is there
> a simple SQL statement to transfer data from one table to another?
>
> I'm basically trying to upsize my Access table, but the Upsize wizard
> constantly craps out.
>
You moving to SQL Server 7? Use DTS instead; pull the data in instead of
pushing. Other than that, drop the data to file (ick I know) and bcp it into
SQL Server....
sgd
--
work: http://www.ti3.com/
non: http://thinksafely.org/
More information about the thelist
mailing list