Renaming excel file with autonumber in MS Access

V

Vladan

Joined
Nov 16, 2008
Messages
1
Reaction score
0
Hello,



I have excel file linked to MS Access database. I am appending new row in DB with data from the excel file. MS Access is creating ID to that row with auto number. I would like to rename linked excel file or create copy of it and automatically rename it to the value of auto number in MS Access. Your help would highly appriciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Renaming columns in MS Query 2
Excel Query setup 0
Run Macro Automatically When Excel 2003 Opens 2
Renaming Access Query used by Excel 1
Refreshing Excel worksheet with data linked from Access 1
Access Import & Link section grayed out MS Access 2010 1
SQL Union in MS Excel 2007 1
Cannot save Project file as MS Access file 1

Top