M
Michael
I am trying to import data from an Excel spreadsheet into
access. It works OK as long has someone in not in the
Excel spreadsheet. I can open the Excel spreadhseet "read-
only" thru Excel but I nothing I know to try works in
Access. I tried using DoCmd.Transferspreadsheet but it
bombs when somone is in the Excel file. (works OK if no
one is using the file. I tried doing a FileCopy first to
make a copy of the Excel file then do a
Transferspreadsheet from my new copy. The Filecopy bombs.
Is there a way to do this?
Thanks.
access. It works OK as long has someone in not in the
Excel spreadsheet. I can open the Excel spreadhseet "read-
only" thru Excel but I nothing I know to try works in
Access. I tried using DoCmd.Transferspreadsheet but it
bombs when somone is in the Excel file. (works OK if no
one is using the file. I tried doing a FileCopy first to
make a copy of the Excel file then do a
Transferspreadsheet from my new copy. The Filecopy bombs.
Is there a way to do this?
Thanks.