Access record transfer to excel

[Lyndseyd]

Hey all,

Just a quick question to see if something is possible or not.

Basically i have a form which the users record errors which have happened with deliveries of our product and have to select the reason why this happened. What i have been asked to do is when the users are entering the reason 'incorrect address', they want to be able to click on a button and everything which they have entered for that record are appended to an excel spreadsheet. The are currently entering it twice...once in my database and once in a spreadsheet and they just want to reduce their workload.

This transfer of data is only needed when that specific reason is chosen from my combo box, no other reason. I don't have much knowledge of Excel, i was just wondering if this type of thing wa possible and if anyone could put me in the right direction. I have had a search for my problem, but havn't found anything similar to my pro. yet.

 

[Ron_dK]

I would suggest to make an export spec and do the export of relevant data from Access to Excel on an once a day basis.
That would save you a lot of trouble in creating all kind of buttons, VB proc etc.

 

[The_Doc_Man]

First, define your problem better. (To yourself, we don't necessarily need to know the answer...) Do you need a single-line spreadsheet for every case of a bad address or can you just tack the new entry on an existing spreadsheet?

Do you need to close out the accumulating list every so often and start a new one?

Is the format of the desired spreadsheet uniform so that you could perhaps link to the spreadsheet as though it were an external table?