Pseudocode of TOR
1. Start
2. Open up Access
3. Import excel
4. Read multiple pages
5. Append to a permanent Access table
6. Use qry to show individual archives
7. Produce a pivot table of archives
8. Filter a menu
9. A.import data
b. Revise duplicates
c. Export pivot table back to excel
d...
Using the power of queries in Access 2010 by linking an excel 2010 table gives me the results where exactly.
In a query i linked
In a table i linked
Both.
My request is to open it up and print it then, right.
Ques. Can i open up the query linked to excel table to find my results?
But i want...
Excel 2010 once in Access 2010 has the power of queries, Its modified in Access 2010 to update all queries, what function does it help to also change the queries to Append.
Should the excel 2010 file inside Access 2010 be linked before or after.
Margarita
Hello,
I need help programming a command button in Access 2010 to import a text file; (the code should have the (all range) delimiter) and by pressing the button, Access 2010 reading the text file should produce the file. Once inside Access, the text file updates my queries.
Thanks,
Marjorie
My code does not work behind the button in my form. I wanted to create a button, importing an excel sheet in one step, for an end user. Then i wanted to create Append queries that also update from the modified excel table i imported. Can the combo pulldown list that holds all the Append...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.