Search the web
Sign In
New User? Sign Up
ms_access · Help and advice for users of MS access
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Want to share photos of your group with the world? Add a group photo to Flickr.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Does Macro Runcommand: ImportAttachExcel alllow the import of Excel   Message List  
Reply | Forward Message #21535 of 21714 |
It sure looks like this is the way to go but my book does not talk
about this run command. I did a search on the web and got little.

I want to set up a macro to import an excel worksheet and overwrite an
existing table. I can't figure out the syntax for this. Can you help?




Tue Jan 13, 2009 2:01 am

phssthpok3
Offline Offline
Send Email Send Email

Forward
Message #21535 of 21714 |
Expand Messages Author Sort by Date

It sure looks like this is the way to go but my book does not talk about this run command. I did a search on the web and got little. I want to set up a macro...
Jan
phssthpok3
Offline Send Email
Jan 13, 2009
2:01 am

You can write a macro to run your queries.   ________________________________ From: Jan <phssthpok3@...> To: ms_access@yahoogroups.com Sent: Monday,...
John Gonnello
johnny100g
Offline Send Email
Jan 13, 2009
3:55 am

Yes, you can import an Excel spreadsheet using this command. You should have the option of importing to a new spreadsheet, or appending to an exsisting one.  ...
Tyrone Lumley
tyrone_topheavy
Offline Send Email
Jan 13, 2009
4:55 am

I have a series of things going on when I import a spreadsheet. Every morning I have to update 11 tables from an outside source. I have a progress bar that...
Jim Wagner
luvmymelody
Online Now Send Email
Jan 13, 2009
3:18 pm

I posted my solution but I guess that it did not come through to my email. please check the user group for my solution. Jim Wagner ...
Jim Wagner
luvmymelody
Online Now Send Email
Jan 13, 2009
3:32 pm
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help