Import Data from Access to SQL Server
-
Hi, I have developed a VB application. That simply have two Database, One source database is MS Access and destination database is SQL Server. Through this application it will import data from source db (Access) to destination db (SQL Server). when running application it works efficiently bout if yo see its status in windows task manager it display as "Not Responding", while it import all data successfully. Does anyone find its solution? Thanks Amit Chowdhury
-
Hi, I have developed a VB application. That simply have two Database, One source database is MS Access and destination database is SQL Server. Through this application it will import data from source db (Access) to destination db (SQL Server). when running application it works efficiently bout if yo see its status in windows task manager it display as "Not Responding", while it import all data successfully. Does anyone find its solution? Thanks Amit Chowdhury
This is because your application is not yielding every once in a while so it's message pump can execute. Inside the loop that is processing your records, include a
Application.DoEvents()statement. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome