Unanswered: Losing Data Using ADO between Access and Excel
I am building an inventory trending database that receives all of its data from imports of Excel spreadsheets and although this is not my ideal solution it matters not my opinion. Anyway I am using an ADODB connection and recordset in Access 2002. I have defined a named dataa space in my Excel 2002 file to allow the query to work properly from Access. It seems like the data will not always fill in properly. I will quite frequently not receive the first record in the spreadsheet (I am assuming that is for header purposes but this does not seem consistent.) Also when I go into Excel and edit some of the data by hand it will end up that the data value is not seen from my Access module. Has anyone had problems with similar situations?