I am an accountant not a programmer but know enough programming to get into trouble. I have written a program to help my company internally process some payroll information. The payroll calculations all work fine. However, I want to save the calculation details out to an Access database table called “TransactionDetails”.
The code below works fine to save the details, but, it takes a very long time to save the information to the Access table. FYI - there are no indexes set in the db table. Moving to SQL is not an option at this time.
Do you have any ideas on how this could be speeded up? For example, could I save the details to a csv file first and then import the csv file in bulk programmatically in to the Access table?
Below is the working, but, slow code. The data I want to save is in a collection of objects called “PayrollDetails”. The collection contains approximately 160,000 objects. Each object, as has about 25 fields within it that I want to save.
I am using vb.net with an Ole db connection.
Here is the code. (Again, it works – all records are saved. It just takes a long time.)
If saving to a csv file first, then, uploading in bulk to the Access table would be faster could you provide me with the code that would work for me? Please nothing complicated, just something that works.
Hello, i can do the vb.net code to save your csv file into access database it is very easy for me payment after job completion waiting your answer Thank you
Bu iş için 4 freelancer ortalamada $83 teklif veriyor
Hello, I have almost 10 years of experience with VB.NET and I have experience with Access too. I have checked attached files and I have some ideas how to improve.
Dear Sir/Madam, Hop you are doing great!. I can help you in writing the program as per your requirements. Looking forward for your positive response. Best Regards, Ijaz Hussain