Home....
Developer Network >> Other Programming >> Database

Adding Large Amount of Records

I have a VB.NET app that gets data from an Access 2000 DB. I want the user to
be able to import/paste data to the DB with through this program in some way.
Getting info from Excel would be the best. I already tried getting info from Excel
into DataSet and then (Psuedo Code):

Access Dataset.Merge (Excel Dataset)

but that doesn't work can anyone give me some pointers?
[405 byte] By [brix_zx2] at [2007-11-19 7:27:43]
«« MFC Hangs on updating data in controls
»» Compressing files?
# 1 Re: Adding Large Amount of Records
Just open excel file as datareader, than loop through the rows and isssue update data commands on Access.

Hope it helps.
Krzemo at 2007-11-9 13:40:41 >
# 2 Re: Adding Large Amount of Records
Now that's an idea I haven't thought of. Thanks I'll let you know how it turns out!
brix_zx2 at 2007-11-9 13:41:41 >
Other Programming
Database

Other Programming

All Classified

Other Programming New Topic

Other Programming Hot Topic