Record Macros in Access 2003?

  • Thread starter Thread starter excelCPA
  • Start date Start date
E

excelCPA

Is it possible to record a macro in Access 2003 similar to Excel?

I need to create a simple macro to automate the process of importing
data from a named range in an Excel spreadsheet and replacing an
existing table in Access. I can't use a create table query because
much of the data is >255 characters and exceeds the linked table
limit.

Thanks in advance.
 
Hi,

     Just use the DoCmd.TransferSpreadsheet command and specify thedesired
data range.  You can use the name of a named range or a range of cells:

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, _
    "Employees","C:\Employees.xls", False, "MyDataRange"

     See the online help for details.

             Clifford Bass
Click to expand...

Thanks, this worked great.
 
Back
Top