There are two sides: a) the user side: if a1:b20 is all the sheet contains, the user could save his sheet as "user.csv" in a particular folder but if the range to import in access is only part of the sheet, maybe I could develop a little macro to export only that part... You tell me ! b) the central access file: I need the layout to write to, but just as an example I will write here a .vbs to write that .csv to your .mdb... by the way, my .vbs could grab the data from without the regular .xls too, but then the initiative is no longer in the user hand, but centralized... You tell me!
till then Paul Willekens -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using "remove me" as the subject.
