Record Macros in Access 2003?

[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.

 

[Clifford Bass via AccessMonster.com]

Hi,

Just use the DoCmd.TransferSpreadsheet command and specify the desired
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

 

[excelCPA]

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

Thanks, this worked great.

 

[Clifford Bass via AccessMonster.com]

Hi,

Great. You are welcome.

Clifford Bass

On Jan 15, 3:08 pm, "Clifford Bass via AccessMonster.com" <u48370@uwe>
wrote:

Thanks, this worked great.