Deleting the file and recreating will definitely solve this for workbooks that only have the one worksheet. Even deleting the worksheet out of an existing book will allow you to recreate the data with an export. However, the user is basically hoping that they can export without those extra steps - and not have data left over from the previous export. As I said... I don't think it is possible.
I just wanted to double check with the group before I tell the user that they can write a macro to do it for them or they can manually delete the sheet. Blank records will also overwrite existing data with nulls so there is that option too. Thanks for the suggestion. --- In [email protected], "Lava Boggavarapu" <[EMAIL PROTECTED]> wrote: > > How about deleting the .xls file and then creating a new .xls file with > the new data? > > > > Lava > > > > ------------------------------------------------ > > Lava Boggavarapu > > Lava Trading Inc. > > 95 Morton Street > > New York, NY 10014 > > > > Tel 212.519.9371 > > Mobile 732.668.2935 > > www.lavatrading.com > > -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of rodger042 > Sent: Thursday, January 05, 2006 11:34 AM > To: [email protected] > Subject: [AccessDevelopers] Exporting to excel and overwriting data > > > > I appologize if this is in the archives somewhere already. If so, I > didn't find it. > > I have a user asking about exporting from access to excel and > overwriting data... here is the scenario > > 1) Take an excel worksheet with a lot of data > 2) Export a table or query from MS Access with the same name as that > worksheet > 3) Receive the option to overwrite > 4) If the data is less than would cover the original data you only > partially overwite the original data - you don't replace the entire > sheet > > Example of sheet filled with 1's that had an export done on it would > look like this > > data 1 1 1 1 1 > 1 1 1 1 1 1 1 > 1 1 1 1 1 1 1 > 1 1 1 1 1 1 1 > > Basically the user would like to be able to export a smaller set of > data over a larger set in excel and have anything that wasn't there > automatically erased. > > I am not aware of a way to facialitate this with a simple togle > anywhere. I'm thinking the only practical way for this to happen > automatically is with a macro. Can someone confirm this for me? OR > better yet, prove me wrong? ;-) > > Thanks for your time > > > > > > > Please zip all files prior to uploading to Files section. > > > > > SPONSORED LINKS > > Microsoft access developer > <http://groups.yahoo.com/gads? t=ms&k=Microsoft+access+developer&w1=Micro > soft+access+developer&w2=Microsoft+access+help&w3=Microsoft+access+da tab > ase&w4=Microsoft+access+training&w5=Microsoft+access+training+course& w6= > Microsoft+access+programming&c=6&s=193&.sig=d- CjBIrYOH9NCKHYFeGZJA> > > Microsoft access help > <http://groups.yahoo.com/gads? t=ms&k=Microsoft+access+help&w1=Microsoft+ > access+developer&w2=Microsoft+access+help&w3=Microsoft+access+databas e&w > 4=Microsoft+access+training&w5=Microsoft+access+training+course&w6=Mi cro > soft+access+programming&c=6&s=193&.sig=crx-d4AAhdklv_VozGVAUw> > > Microsoft access database > <http://groups.yahoo.com/gads? t=ms&k=Microsoft+access+database&w1=Micros > oft+access+developer&w2=Microsoft+access+help&w3=Microsoft+access+dat aba > se&w4=Microsoft+access+training&w5=Microsoft+access+training+course&w 6=M > icrosoft+access+programming&c=6&s=193&.sig=qg2hDuQNweByMCX0NU7cEA> > > Microsoft access training > <http://groups.yahoo.com/gads? t=ms&k=Microsoft+access+training&w1=Micros > oft+access+developer&w2=Microsoft+access+help&w3=Microsoft+access+dat aba > se&w4=Microsoft+access+training&w5=Microsoft+access+training+course&w 6=M > icrosoft+access+programming&c=6&s=193&.sig=bLZHqTqWUQny609X1OkmNA> > > Microsoft access training course > <http://groups.yahoo.com/gads? t=ms&k=Microsoft+access+training+course&w1 > =Microsoft+access+developer&w2=Microsoft+access+help&w3=Microsoft+acc ess > +database&w4=Microsoft+access+training&w5=Microsoft+access+training+c our > se&w6=Microsoft+access+programming&c=6&s=193&.sig=d8GQXfQW3RZ64rOfzIM o8A > > > > Microsoft access programming > <http://groups.yahoo.com/gads? t=ms&k=Microsoft+access+programming&w1=Mic > rosoft+access+developer&w2=Microsoft+access+help&w3=Microsoft+access+ dat > abase&w4=Microsoft+access+training&w5=Microsoft+access+training+cours e&w > 6=Microsoft+access+programming&c=6&s=193&.sig=iXDlL79- kkgjv6fLyFu3Sg> > > > > ________________________________ > > YAHOO! GROUPS LINKS > > > > * Visit your group "AccessDevelopers > <http://groups.yahoo.com/group/AccessDevelopers> " on the web. > > > * To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED] subject=Unsubscribe > > > > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of > Service <http://docs.yahoo.com/info/terms/> . > > > > ________________________________ > > > > The information contained in this message and any attachments (the "Message") is intended for specific individual(s), and may be confidential or proprietary. If you are not the intended recipient, please notify the sender immediately, delete this Message and do not disclose. Messages are not secure or error free and can contain viruses and the sender is not liable for any of these occurrences. The sender reserves the right to monitor, record and retain Messages. > Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
