Link Excel file to MS Access and generate rep
Closed
Archiee
-
Feb 9, 2011 at 07:08 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 28, 2011 at 05:58 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 28, 2011 at 05:58 AM
Related:
- Link Excel file to MS Access and generate rep
- Ms access download - Download - Databases
- Windows 10 iso file download 64-bit - Download - Windows
- Kmspico zip file download - Download - Other
- Ms office save as pdf or xps file - Download - Other
- Whatsapp group link not working ✓ - WhatsApp Forum
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 9, 2011 at 08:13 AM
Feb 9, 2011 at 08:13 AM
you need to provide more information
Could you please upload a sample files WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.
Note: your data need not be to be real data but a good representative of how data looks like
Could you please upload a sample files WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.
Note: your data need not be to be real data but a good representative of how data looks like
Hi,
Please find link to the file below:
http://wikisend.com/download/402076/For Mr. Riz.xlsx
You will see several columns I want all of it as table in Access database. I want user to search on any of the main criteria mentioned earlier and users will get to see only the relevant information instead of sharing the complete excel file. Hope you are able to understand my problem.
Regards,
Archiee
Please find link to the file below:
http://wikisend.com/download/402076/For Mr. Riz.xlsx
You will see several columns I want all of it as table in Access database. I want user to search on any of the main criteria mentioned earlier and users will get to see only the relevant information instead of sharing the complete excel file. Hope you are able to understand my problem.
Regards,
Archiee
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 17, 2011 at 08:15 AM
Feb 17, 2011 at 08:15 AM
There are lot of questions on your book. If you want data to be in Access, then why do you even need excel ?
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 27, 2011 at 04:05 PM
Feb 27, 2011 at 04:05 PM
How much of data are you thinking about eventually. If 1000 row is all that you have then you can still live in excel world. the data could be housed in a hidden sheet and you could provide user and interface in excel to do search and get the row for them
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 28, 2011 at 05:58 AM
Feb 28, 2011 at 05:58 AM
There are various approaches to data entry. Depends on situation. One could be that you provided a form where user enters the data and then click on save and then data is saved on that hidden row. Other approach could be that you have a dummy sheet upfront where users will enter the data and once they click on save (or some action that you define indicate that user wants to save) then copy the data to hidden sheet and clean out the dummy sheet blank
