what does your catch exception say? if you have the finally part in your code..remove it for now to catch your exception. That should tell you why its not working. I had the same problem until i removed the finally part to see the exception.
I am receiving the error:
The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.Thoughts?
UPDATE: I looks like this is a 64 bit issue. Did you run into this?
No, I didn't.. I have a 32bit Windows XP...so yeah mostly likely you have a 64bit issue..could you please check and verify that here? Are you using XP or WINDOWS 7? also are you using any express versions?
I figured out my problem for the following error The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine. I had to adjust my application pool to use 32 bit applications. Once I changed this, it worked perfectly with the code that Brownsound90
supplied.
jthomas8946
Member
181 Points
240 Posts
Re: Import Data from .CSV to SQL from FileUpload
May 07, 2012 01:52 PM|LINK
I am receiving the error: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.Thoughts?
UPDATE: I looks like this is a 64 bit issue. Did you run into this?
pierrefrc
Participant
947 Points
201 Posts
Re: Import Data from .CSV to SQL from FileUpload
May 07, 2012 01:54 PM|LINK
Hi
You need to install the MDAC (Microsoft Data Access Components).
It's this link: http://www.microsoft.com/en-us/download/details.aspx?id=5793
brownsound90
Member
14 Points
8 Posts
Re: Import Data from .CSV to SQL from FileUpload
May 07, 2012 03:12 PM|LINK
No, I didn't.. I have a 32bit Windows XP...so yeah mostly likely you have a 64bit issue..could you please check and verify that here? Are you using XP or WINDOWS 7? also are you using any express versions?
jthomas8946
Member
181 Points
240 Posts
Re: Import Data from .CSV to SQL from FileUpload
May 08, 2012 01:20 PM|LINK
I figured out my problem for the following error The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine. I had to adjust my application pool to use 32 bit applications. Once I changed this, it worked perfectly with the code that Brownsound90 supplied.
Thanks!