Corrupt MS Access on PC?

[smedvid]

Has anyone ever seen this? User has MS Access 97, 2002 and 2003 on PC. MS Access DB will not import MS Excel file via

DoCmd.TransferSpreadsheet acImport, lnExcelVersion, "tbl_Temp_Funded_Data", Me.txtInputLoc.Value & Me.Lst_Files.Value, True

lnExcelVersion - I set this to 8 ; "Excel 97 to Excel 2002".

Some columns are not being imported and place a null value into a temp table.

Can not reproduce issue on my PC; and employee's manager PC not reproduce issue. We should all have same PC image with MS softare per IT Group!

So, do I have corrupt MS Access library; registry issues or corrupt MS Excel? Any clues are appreciated.

tia,


Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[JerryKlmns]

Steve

Have you checked the excel file to see if those not imported columns, are out of printing area? Another issue is when there are subtotals in the sheet or active filters on!

 

[smedvid]

The excel file appear fine; in fact, the file imports correctly on another PC. I actaully tested (3) PCs that are Ok. Issue appears isolated to (1) PC. Strangest thing I've ever observed. User also reported a message Out of Resources message when attempting to save a large MS Excel file; but user has 5GB Free and 2GB RAM. So, maybe MS Excel or related library are the issue? Thanks for input...

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...