I have and excel sheet with fields: Name | Surname | Dept. When I execute the following code, it imports 16 empty rows + filled ones
Expand|Select|Wrap|Line Numbers
- DoCmd.TransferSpreadsheet acImport = 0, acSpreadsheetTypeExcel9 = 8, _
- "importowaneDane", sciezkaPliku, True
I also tried to execute this:
Expand|Select|Wrap|Line Numbers
- CurrentDb.Execute ("DELETE FROM importowaneDane " & _
- "WHERE Dept = ''")