Last post Jul 13, 2015 07:29 AM by Nan Yu
Jul 12, 2015 07:54 PM|ManyTitles|LINK
Hi all, I have rows of data in an Excel spreadsheet which I would like to bulk insert into specified fields in a database table. The problem I am having is that the spreadsheet does not contain the same number of fields as the table in the database. Also
the fields in the spreadsheet are not in the same order as those in the database table.
I have tried to use the Import Export wizard to import the data from the spreadsheet to the database table but it gave me an error saying something about Microsoft.ACE.OLEDB.12.0 provider not found on my machine. So I was hoping that someone can help suggest
a work around using Bulk Insert. Thanks in advance.
Jul 12, 2015 07:57 PM|mostafasydney|LINK
Microsoft.ACE.OLEDB.12.0 provide not found on my machine
You need to check the library has been referenced or not.
Jul 13, 2015 07:29 AM|Nan Yu|LINK
Hi ManyTitles ,
Please try to visit the following download link for downloading 2007 Office System Driver: Data Connectivity Components.
Also Install Microsoft Access Database Engine 2010 Redistributable:
For more information ,please refer to links below: