Export records into Excel

[Mike Busch]

I would like to export one record at a time to an excel spreadsheet. I would
also like all records that I create to be exported this way and added to the
same spreadsheet. Is this do-able without a lot of programming. Thanks in
advance

 

[Klatuu]

Not without some prgramming.
Why would you want to do this? It would be terrible inefficient.
What are you trying to accomplish? Pehaps if you would share the objective,
we can suggest a better method.

 

[Mike Busch]

OK this is what we are trying to do. We have an Access Database that houses
our Requisitions system. The final report is a mimic of our Req form that was
always hand written. If we can put this into a spreadsheet, we would be able
to track approvals and status for our requisitions that we creat, and add
PO's and other information that is needed.

 

[Klatuu]

Why not do it all in Access?
The problem you have is that when exporting to Excel, the data you export
this time will replace the data exported last time, so in you export one
record, that is all that will ever be in the spreadsheet.

You could use automation to add new lines to the spreadsheet, but then you
have a problem in that if users are using the spreadsheet, you will get into
some locking contention.

Your options to consider would be to print a paper report per new req to be
distributed, Use Access for everything, or create a new spreadsheet for each
new req and combine them into one using Excel at some point in time.
I would suggest you seriously consider using Access for the entire process.

 

[Raymond]

Hi,

User must have their reason if they need some Excel spreadsheet instead of
doing all in MS Access.
Yes, it is possible to export to EXCEL line by line. You can find some help
from the Internet.

Wish I can help.
Raymond

 

[Klatuu]

I did not say it could not be done, Raymond. I said it would be more
difficult to export line by line and then recombine and import back into
Access.
Nor did I say to use Access. I was asking why not keep it in Access? You
are correct that there may be a reason to do it that way, but unless there is
some overriding business rule or unreasonable manager, it would be easier and
more reliable to keep it in Access.

If the OP absolutely required Excel, I can and will be happy to assist.