Copy Records from one excel spreadsheet to another excel spreadsheet

  • Thread starter Thread starter chris_quinn26
  • Start date Start date
C

chris_quinn26

I am trying to create a macro that will append records from one excel
spreadsheet to another excel spreadsheet with access 2003. Later I am
going to populate some cells with an existing table in my access
program, but this is my problem for right now. I want to leave all
records in excel because of my conditional formatting and formulas. Is
this possible? Any help would be greatly appriciated.
 
Hi Chris,

It's possible but not easy. You have to write VBA code that launches
Excel, opens the workbook, and puts the values into the appropriate
cells. If you search (e.g. at Google Groups) for something like

group:microsoft.public.access.externaldata export automation excel
formatting

you'll see the sort of thing that's involved.
 
You must log in or register to reply here.

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
Exporting Data from Access To Excel 10
Open Excel Spreadsheet 2
How do i update Access Table using data from Excel spreadsheet 3
Importing spreadsheet cells that have multiple values 1
Refreshing Data Daily From a Linked Excel Spreadsheet 2
Linking Multiple Excel Spreadsheets 3
Export Data from Queries in Access 2007 to Excel Spreadsheet 1

Back
Top