Transfer data from spreadsheet
- Thread starter Thedon123
- Start date
Thedon123
Registered User.
- Local time
- Today, 22:47
- Joined
- Sep 11, 2002
- Messages
- 98
just to clarify i have used the transfer spreadsheet fucntion. the problem is the name of the file keeps on changing. is there a way that gives the ability for the user to selct the spreadsheet path name that is to be transferred
thanks
thanks
Assuming that you are using a version of Excel as the spreadsheet then it is possible to transfer data from a spreadsheet to a databse using 'Template wizard' locate in the data menu. (you may hav to install this as an add-in as it isnt installed as standard).
This creates a template spreadsheet and allows you to keep on transfering data to the database regardless of the file name that the spreadsheet is saved as.
I hope this helps
This creates a template spreadsheet and allows you to keep on transfering data to the database regardless of the file name that the spreadsheet is saved as.
I hope this helps
Thedon123
Registered User.
- Local time
- Today, 22:47
- Joined
- Sep 11, 2002
- Messages
- 98
thanks for the reply. the only thing is that i need the user to click on button that will ask him to transfer tthe data into a table,.
i have table called store.
the spreadsheet holds data that is genrated evry week. these spreadsheets have different names
i want the user to click on a button in the database that wll ask him to choose the excel file. then it will automatically transfer the data.
i have table called store.
the spreadsheet holds data that is genrated evry week. these spreadsheets have different names
i want the user to click on a button in the database that wll ask him to choose the excel file. then it will automatically transfer the data.
Is it neccessary for the user to have to carry out a command for the process to take place? It is possible to automate the entire process automatically and for the data to transfer itself at at the end of each week without having to be commanded to do so.
It is also possible to set up a template wizard to retrieve data from more than one spreadsheet as long as you create the fields in the first place when setting up the wizard.
Other than using this method i think that some VB code will have to be created within the database to retrieve the data when a button is clicked. I`m not proficient enough top help you with this sorry.
It is also possible to set up a template wizard to retrieve data from more than one spreadsheet as long as you create the fields in the first place when setting up the wizard.
Other than using this method i think that some VB code will have to be created within the database to retrieve the data when a button is clicked. I`m not proficient enough top help you with this sorry.
bradcccs
Registered User.
- Local time
- Tomorrow, 09:47
- Joined
- Aug 9, 2001
- Messages
- 461
You could use the following principle to enable the user to locate the file name & path.
Note: The attached demo uses the comdlg32.dll file location window.
I don't know who to credit for the code, but I obtained it (with thanks) from OldSoftBoss.
You will have to manipulate it to suit. - The demo is set to locate image files, but if you have some coding knowledge, you will find it very suitable to your purpose.
HTH
Brad.
Note: The attached demo uses the comdlg32.dll file location window.
I don't know who to credit for the code, but I obtained it (with thanks) from OldSoftBoss.
You will have to manipulate it to suit. - The demo is set to locate image files, but if you have some coding knowledge, you will find it very suitable to your purpose.
HTH
Brad.
