SQLT able into Access

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

Guest

I have A SQL database with a Contacts table of about 2.9 million records.

I setup a project in access linking to the SQL database.

Of the 2.9 Milion records in the contacts table, i need to retrive the
customers with a activitycode of Convert Only in the table, .Maybe 300,000 to
400,000 Customers

Can Access handle this amount of records from a SQLTable.

I need to Upadte the information on the Converted customers and update it to
SQL database.

Tanks
Peter
 
If you just want to run a query that will update records in the SQL
server table, there shouldn't be any problem.

If you want to import a few hundred thousand records into an Access/Jet
(.mdb) database, work on them and then export them back to the server
database - that's not likely to give Access any trouble either.
 
Back
Top