Tamamlanmış

vb.net csv to Access table

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.)

Any ideas?

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.

Beceriler: VB.NET, SQL

Daha fazlasını gör: net csv access, visual basic net csv access, access table map example, load csv access table vbnet, asp net import csv access table, datagrid vb net csv, fast vb net csv, import csv access table vb net, progress bar vb net csv, project source code online advertising agency asp net vb net ms access, sql server vb net metadata create table, vb imports csv access, vb net code access files computer, vb net csv file, vb net csv file web scraper, vb net csv grid, vb net csv import data grid

İşveren Hakkında:
( 0 değerlendirme ) Kaysville, United States

Proje NO: #22043562

Seçilen:

Ahmed818

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

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(38 Değerlendirme)
4.9

Bu iş için 4 freelancer ortalamada $83 teklif veriyor

vano101

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.

$30 USD in 2 gün içinde
(76 Değerlendirme)
5.8
IjazSe

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

$250 USD in 3 gün içinde
(6 Değerlendirme)
3.4
khaldalfalah

Hi,I am ready to help you on your project , i can see some issue in your code cause slowing. I have experience in MS SQL server,asp.net, crystal reports and VB.net more than 12 years. CV: I am software engineer, Hold Daha Fazla

$30 USD in 3 gün içinde
(3 Değerlendirme)
1.6