Thanks for responding... In my DB there is a main table that houses all current data. I can use the transfer spreadsheet to pull in the current data without a problem. But, before that happens that data that sits in the main table (thats no longer current) needs to be copied into a separate table with the name being the date. To keep track of history.
It looks like I can use either the Transfer Spreadsheet or the CopyObject function to do this...Is there not code I can use in the NEW NAME argument to distinguish that I want a prompt. Like in a make-table query or a simple copy/paste function. I'd like the copy of old and the import of new to happen in one movement to the user. I'm very novice regarding VBA and have only done a few things. I understand what you are saying but don't have any idea how to go about it. Appreciate any help! Jeanette~ >>> [EMAIL PROTECTED] 3/28/2006 2:38:29 AM >>> Jeanette It may be better to use VBA in which you can use CopyFolder method to enable the user to browse for the filename. You can then use the filename in your TransferSpreadsheet method. If the path is always the same, then you can use Inputbox for the user to enter the filename which you can use in your TransferSpreadsheet method HTH Liveson ----- Original Message ----- From: "Jeanette Garcia" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, 27 March, 2006 21:27 Subject: [ms_access] Import Inquiry My IS dept runs a datadump for me and places on the network. The path is always the same but the file name is the date. With a changing file name, it makes the auto-import that I'd like to add into the database that accepts this information more difficult. Is there a way to add into the TransferSpreadsheet macro action to put the path but then a prompt for file name? It will always go into the same repository table within the database. Just need a way for it to know which file to import. Your help is very much appreciated! Jeanette~ ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. Yahoo! Groups Links YAHOO! GROUPS LINKS Visit your group "ms_access" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. *** IMPORTANT: Do not open attachments from unrecognized senders *** ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> 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/
