Forums :: Import/Export Tools

DwZone Forum
Welcome to the DwZone-it Forum

FAQ

Memberlist

Usergroups

Import/Export Tools

DwZone Forum Index -> Import/Export Tools
.
Moderators: Administrators, Moderators

Mark all topics read

Hint: For improved responsiveness, use Internet Explorer 4 (or above) with Javascript enabled, choose 'Dynamic' from the View dropdown and hit 'Set Options' to save your changes.

	Search for
View Per page Messages Since

Messages 1 to 10 of 88 (Total: 87)

First | Prev | Next | Last

Subject

Author

Date

CSV import from external site

Adrian Smith

8:25 11 Sep 2019

Excel import error on new host

Sharon

8:21 5 Nov 2018

The import works fine on two other hosts. The new host says I need to create an ODBC using the Excel driver but I did not have to do this on the other hosts. Here is the error:

****
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/dwzExport/ExcelImport.asp, line 492
****

Here is line 482 to 492:

****
private sub readFromExcelContent()

if sXlsConnString = "" then
sXlsConnString = "Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DriverId=1046;DBQ=#DBQ#;DefaultDir=#DefaultDir#;"
else
sXlsConnString = replace(sXlsConnString, "#DBQ#", FullFilePath, 1, -1, vbtextcompare)
sXlsConnString = replace(sXlsConnString, "#DefaultDir#", getDir(FullFilePath), 1, -1, vbtextcompare)
end if

Set xlsConn = Server.CreateObject("ADODB.connection")
xlsConn.Open sXlsConnString
****

Any suggestions? Do I need to make an ODBC connection, and if so, what are the settings? Thanks.

MzLiberty