General information
Forum:
Microsoft SQL Server
Title:
DBASE IV and a SQL Table Update
Environment versions
SQL Server:
SQL Server 2000
I have a DBASE IV file that is stored on my workstation with several columns of which there are two columns of data I need to transfer to a SQL table. The dbase IV table and the SQL table have a common column between them. The common field contains an integer value that tie the records in the dbase file to the SQL table. How do I open the dbase IV file in query analyzer and join it to the SQL table? Once I join the tables the table I need to update the SQL table. There are over 1,000,000 records in each table. To prevent the production server from being over whelmed, the SQL script will have to process approximately 5,000 records at a time. Not every record in the DBASE IV file will have data that is transferred.
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only