Avatar of Murray Brown
Murray BrownFlag for United Kingdom of Great Britain and Northern Ireland asked on

Access VBA View newly imported table

Hi


I am importing an Excel file into Access using the following code. How do I view the table data without a form having been assigned to it. The format and columns of the data will change so I want to be able to  view the data after load. Is there a way to have a multipurpose form that can load any table


    DoCmd.TransferSpreadsheet acImport, , "New Table", F, True

VBAMicrosoft Access

Avatar of undefined
Last Comment
Jim Dettman (EE MVE)

8/22/2022 - Mon
Jim Dettman (EE MVE)

<<The format and columns of the data will change so I want to be able to  view the data after load.  >>

 Not sure I understand the question in terms of intent, but as long as the table name doesn't change, you can have a query defined as:

 SELECT * FROM <table name>

 and open that in code after the import.   You'll get the query output on the screen.

 Even more simply, just open the table from the database container, but I'm assuming you meant this from an end user perspective.

 That's what I meant about not understanding;  who and how will this functionality need to be used.

Jim.
ASKER
Murray Brown

Hi Jim
I really just want the user to see the table in a read only format. I also want it to be a pop out.
Thanks

ASKER CERTIFIED SOLUTION
Jim Dettman (EE MVE)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy