August 2, 2012 at 9:49 am
I need to import a .xls file in to SQL server. When I go into task/import from the DB I get this error.
the dbproviderfactories section can only appear once per config file
I found a site when I googled it that said there are duplicate entries in the machine.config file. FOund the file but didn't find the duplicate entries. I just got a new machine and got SQL server set up on it. The last machine didn't do that. What could be causing this error?
Perplexed.
Quinn
August 2, 2012 at 9:56 am
Try saving as CSV and import that?
August 2, 2012 at 10:15 am
Are you referring to this link?
August 2, 2012 at 2:49 pm
Thanks Kirby. That link did it.
I really apreciate it.
Quinn
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply