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.
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/
