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

  • Thread starter Thread starter Avid Fan
  • Start date Start date
A

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.
 
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".
 
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.
 
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.
Click to expand...

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