I need to do this:
strsql="INSERT INTO tempUPS (ShpPrimary, m_amount, m_amountActual, m_serviceType) IN 'C:\Shipping Database\temp.mdb' SELECT m_primaryKey, m_amount, m_amountActual, m_serviceType FROM calShipment, tempUPS WHERE tempUPS.PkgForeign = calShipment.m_foreignKey;"
The above statement gives this error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'tempUPS'. Make sure it exists and that its name is spelled correctly.
/ups.asp, line 22
How do I make sure that the Driver knows where to find the tempUPS table used in the first part of the INSERT Statement??? Thanks
Topic Options
Post Options
Thanks(0)
