Re: Importing Excel Spreadsheet

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hey Rick,

Sorry, here's the code. It probably makes it easier to see.

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9,
"tblAgentTemp", FTP_PATH & File_Name, True, "0-499!"

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblAgentTemp",
FTP_PATH & File_Name, True, "500-999!"


If I changed the name of the worksheets from 0-499 to ZipZone1 the above
code works perfectly.

"Rick A.B." wrote:

On Apr 29, 12:26 pm, mattieflo <mattie...@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
Hello,

I'm trying to import two worksheets titled 0-499 and 500-999. However,
apparently my code does not recognize work*** names with those numbers (or
maybe I'm coding wrong). Is there an issue with importing work*** with
numbers as its title and if so, is there a way to import these w/o having to
change the work*** names?

Difficult to tell if your code is causing the problem with out seeing
your code. If I had to quess I would think that even though the
worksheets titles appear to be numbers they are most likely text not
numbers.

Hope that helps.

Rick

.

Quantcast