Link to Excel files and run an append query

[Suresh]

I am trying to link an excel file into access database and use an
append query to add lines to the excel file. I use to do this for a
longtime until the new excel 2003 service pack was loaded. After
upgrading the service packs I am having a problem wherein access is
unable to update into the excel file due to known/documented microsoft
issues. I have tried access 2003 and 2007 together with excel 2003 and
2007. (i am unable to link an xlsx file to access 2007!)

Are there any work arounds. Any assistance/links to possible solutions
will be highly appreciated.

regards,

[HS Hartkamp]

A workaround would be to use 'automation' where you create an Excel object
in the VBA code in Access. There you create an object objXL and use that to
do whatever you want to do with the spreadsheet. (don't forget to reference
the excel library if it doesn't work)

If you need to know the way Excel's object model is set up, record some
macros in excel, and read the VBA code within excel.

The positive side is that this is very flexible. You can do whatever you
want to do in a very specific way.
The negative side of this is that it's quite a lot of work. Best to search
the internet and copy some example code.

Wouldn't removing the service pack also work ?

Bas Hartkamp.

"Suresh" <ipsu...@gmail.com> wrote in message
news:c6df212d-2aae-4e48...@upsg2000gro.googlegroups.com...

[Robert Dirr]

Try automating Excel.
The Excel Range object should have a: CopyFromRecordset method

Bob Dirr
_________________________
"HS Hartkamp" <hart...@wanadoo.nl> wrote in message
news:72baa$4b458de6$5354c211$25...@cache1.tilbu1.nb.home.nl...