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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Call Access macro using Excel VBA 1
How to count table records in a macro 1
Automate Macros in ACCESS 2003 1
How to Create a Macro to Import External Data 0
Bulk Import DBF files to access 2003 1
recording macros in access 2003 2
Access Automatically Send a notification email once a record is added 0

Back
Top