change linked sheet name
in [General]
|
From: webeinky on 24 May 2010 15:10 Hi, I have Access programs that are linked to Excel spreadsheets. Due to circumstances beyond my control the sheet names have been changed and I will have to use the new names in my programs. I have tried to go into Link Manager but it does not let me change the sheet name only the file name. Does anyone know an easy way to change the Sheet name in a linked Excel spreadsheet without messing up the connections in queries etc. Thank you in advance for your help -- Nancy
From: golfinray on 24 May 2010 15:49 When you go to the linked table manager, click the button down at the bottom that say "always check for new location." Then give it the new name and file location. -- Milton Purdy ACCESS State of Arkansas "webeinky" wrote: > Hi, > > I have Access programs that are linked to Excel spreadsheets. Due to > circumstances beyond my control the sheet names have been changed and I will > have to use the new names in my programs. > > I have tried to go into Link Manager but it does not let me change the sheet > name only the file name. > > Does anyone know an easy way to change the Sheet name in a linked Excel > spreadsheet without messing up the connections in queries etc. > > Thank you in advance for your help > > -- > Nancy
From: webeinky on 24 May 2010 16:01 Golfinray, Thank you for the speedy reply. I have clicked on the "always check for new location". It is the SHEET name I am trying to change (same location and file name). I did try to include the sheet name such as: e:\Folder\filename.xls\'Sheet1$' but it says it is not accessible. -- Nancy "golfinray" wrote: > When you go to the linked table manager, click the button down at the bottom > that say "always check for new location." Then give it the new name and file > location. > -- > Milton Purdy > ACCESS > State of Arkansas > > > "webeinky" wrote: > > > Hi, > > > > I have Access programs that are linked to Excel spreadsheets. Due to > > circumstances beyond my control the sheet names have been changed and I will > > have to use the new names in my programs. > > > > I have tried to go into Link Manager but it does not let me change the sheet > > name only the file name. > > > > Does anyone know an easy way to change the Sheet name in a linked Excel > > spreadsheet without messing up the connections in queries etc. > > > > Thank you in advance for your help > > > > -- > > Nancy
From: golfinray on 24 May 2010 16:18 All you changed was the name of the sheet? Are there multiple sheets? If so, try importing (file/get external data) to bring the sheet into the database. Then if necesasary copy that sheet back to its original loaction and try linking again. If there are multiple sheets on each it may not know which sheet to bring in. -- Milton Purdy ACCESS State of Arkansas "webeinky" wrote: > Golfinray, > > Thank you for the speedy reply. I have clicked on the "always check for new > location". > > It is the SHEET name I am trying to change (same location and file name). I > did try to include the sheet name such as: e:\Folder\filename.xls\'Sheet1$' > but it says it is not accessible. > -- > Nancy > > > "golfinray" wrote: > > > When you go to the linked table manager, click the button down at the bottom > > that say "always check for new location." Then give it the new name and file > > location. > > -- > > Milton Purdy > > ACCESS > > State of Arkansas > > > > > > "webeinky" wrote: > > > > > Hi, > > > > > > I have Access programs that are linked to Excel spreadsheets. Due to > > > circumstances beyond my control the sheet names have been changed and I will > > > have to use the new names in my programs. > > > > > > I have tried to go into Link Manager but it does not let me change the sheet > > > name only the file name. > > > > > > Does anyone know an easy way to change the Sheet name in a linked Excel > > > spreadsheet without messing up the connections in queries etc. > > > > > > Thank you in advance for your help > > > > > > -- > > > Nancy
From: webeinky on 24 May 2010 16:32 Yes, all that has changed is the name of the sheet. (this all has been caused because the software program that we use to export the data from into an Excel spreadsheet used to name the tab in Excel the same as the Excel file name..now it is Sheet1. We just did a software update, that is why there has been a change) Before the update there was only one tab created in Excel (named the same as the file name). Now there are three tabs - Sheet1, Sheet2 Sheet3 - with Sheet2 and Sheet3 are blank. Right now my Access Program in Linked Table Mananger shows e:\Folder\filename.xls\filename$ as the link path and I want to change it to e:\Folder\filename.xls\Sheet1$ Thanks, Nancy -- Nancy "golfinray" wrote: > All you changed was the name of the sheet? Are there multiple sheets? If so, > try importing (file/get external data) to bring the sheet into the database. > Then if necesasary copy that sheet back to its original loaction and try > linking again. If there are multiple sheets on each it may not know which > sheet to bring in. > -- > Milton Purdy > ACCESS > State of Arkansas > > > "webeinky" wrote: > > > Golfinray, > > > > Thank you for the speedy reply. I have clicked on the "always check for new > > location". > > > > It is the SHEET name I am trying to change (same location and file name). I > > did try to include the sheet name such as: e:\Folder\filename.xls\'Sheet1$' > > but it says it is not accessible. > > -- > > Nancy > > > > > > "golfinray" wrote: > > > > > When you go to the linked table manager, click the button down at the bottom > > > that say "always check for new location." Then give it the new name and file > > > location. > > > -- > > > Milton Purdy > > > ACCESS > > > State of Arkansas > > > > > > > > > "webeinky" wrote: > > > > > > > Hi, > > > > > > > > I have Access programs that are linked to Excel spreadsheets. Due to > > > > circumstances beyond my control the sheet names have been changed and I will > > > > have to use the new names in my programs. > > > > > > > > I have tried to go into Link Manager but it does not let me change the sheet > > > > name only the file name. > > > > > > > > Does anyone know an easy way to change the Sheet name in a linked Excel > > > > spreadsheet without messing up the connections in queries etc. > > > > > > > > Thank you in advance for your help > > > > > > > > -- > > > > Nancy
|
Next
|
Last
Pages: 1 2 Prev: Combo Box Issue Next: DLookup (populating text based on other selections on form) |