I am trying to import an Excel worksheet; however, if the tab has a space in the word, it won't pull in. If I adjust the tab word, it will pull in:
Private Sub OpenOrders_Click()
DoCmd.TransferSpreadsheet acImport, 8, "UPS COM Test", "D:\Amy\ontime.xls", True, "UPS COM Data!"
End Sub
UPS COM Data - won't pull in
UPSCOM - will pull in
Private Sub OpenOrders_Click()
DoCmd.TransferSpreadsheet acImport, 8, "UPS COM Test", "D:\Amy\ontime.xls", True, "UPS COM Data!"
End Sub
UPS COM Data - won't pull in
UPSCOM - will pull in