Previous Topic Next Topic

Link Excel file to MS Access and generate rep

Closed
Archiee - Feb 9, 2011 at 07:08 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 - Feb 28, 2011 at 05:58 AM
Hello,

I have an Excel file with 1000 lines of Information. I would like to link this file to MS Access and have one windows wherein it will ask user to enter Product ID/ or Product Type/ or Supplier Name. If the information is found it should be displayed with the complete Row details from Excel file.

Can someone guide me how to build the table, query and report as I am a beginner in MS Access.

Thanks and regards,
Archiee

2 replies

Answer 1 / 2
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 770
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
0
Answer 2 / 2
Archiee
Feb 9, 2011 at 08:26 AM
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
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 770
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 ?
0
Archiee
Feb 19, 2011 at 12:00 AM
there are several pivot table reports that are in use. Also Data entry is very easy in excel.
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 770
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
0
Archiee
Feb 28, 2011 at 12:46 AM
It would be just great if I could do that in excel. Can you advice how i can do it. Please also remember that data is being added to the file on daily basis if u hide the sheet than how will data entry operators work. Look forward to your response.
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 770
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
0