Search results

  1. L

    ImportExport Spreadsheet using Macro *overwrite existing table*

    I am using Access 2010. No warning thought the file just overwrote the table untill I looked and noticed I had 2 days of date in one table. I've used the Macro Builder and selected: !ImportExport Spreadsheet Transfer Type: Import Spreadsheet Type: Excel Workbook Table Name: "XXX" File Name...
  2. L

    ImportExport Spreadsheet using Macro *overwrite existing table*

    Hihi, hoping someone can help me, I am writing a macro where I am importing an Excel file (pretty standard -nothing fancy) after the macro has run the table has duped. Meaning I didn't get the message "Overwrite existing table or query file" like you get when you import a file manually...
Back
Top Bottom