I want to transfer data from a filtered datasheet to a spreadsheet.

[Avid Fan]

What is the best way to do it.

I have a tabbed form

I have a linked excel spreadsheet which is a report that gets sent to
the boss every week.

Data starts at row 5 in the excel spreadsheet.

I want to filter records and send it to the spreadsheet.

What is the best way.

 

[Dorian]

Best way is to forget about Excel and to create the report in Access to send
to the boss.
The opnly reason to do it the way you are would be if other people needed to
add to the spreadsheet after you created the report.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[Avid Fan]

Ahhh if only it was that easy. This boss (fortunately not my boss) not
gets the same excel report from everyone of his reports. Maybe he cuts
and pastes the results it one big spreadsheet, maybe he chisels it in stone.

As he wrote the report spreadsheet I doubt he will listen to logic.

This stuff used to be quite easy. I remember older versions of Access
you could link excel into your data base as a linked table and change
cells as if they were just fields in a database.

Linked files seem to be read only for some reason.

I am playing with OLE but strange things are happening.

I am new to access from VFP and this recordset stuff is not getting in.

 

[John W. Vinson]

This stuff used to be quite easy. I remember older versions of Access
you could link excel into your data base as a linked table and change
cells as if they were just fields in a database.

Linked files seem to be read only for some reason.

Microsoft was obliged to remove this capability as the result of a lawsuit.

 

[PieterLinden via AccessMonster.com]

Ahhh if only it was that easy. This boss (fortunately not my boss) not
gets the same excel report from everyone of his reports. Maybe he cuts
and pastes the results it one big spreadsheet, maybe he chisels it in stone.

As he wrote the report spreadsheet I doubt he will listen to logic.

This stuff used to be quite easy. I remember older versions of Access
you could link excel into your data base as a linked table and change
cells as if they were just fields in a database.

I would start here:
http://www.mvps.org/access/modules/mdl0035.htm

Basically, you could probably create the recordset by pointing at the form's
recordsetclone. Then send that to Excel by using CopyFromRecordset. You
should be able to put the resulting recordset anywhere you want.

like
.Range("A2").CopyFromRecordset rs

 

[Avid Fan]

Microsoft was obliged to remove this capability as the result of a lawsuit.

You are kidding right?

 

[Avid Fan]

On 6/04/2010 3:37 PM, PieterLinden via AccessMonster.com wrote:

Thanks for this

 

[John W. Vinson]

You are kidding right?

Wish I were!

Google for "microsoft access excel lawsuit". Tons of hits.