import from ms access table name unknown

's Computer Specifications

i need to import a table into ms access from ms access. there will only be one table, but i can't rely on the name of the table being the same each time the report is executed.
how?
tia,
mcnewsxp

's Computer Specifications

On Tue, 6 Mar 2012 07:56:00 -0800 (PST), mcnews <(E-Mail Removed)>
wrote:

>i need to import a table into ms access from ms access. there will only be one table, but i can't rely on the name of the table being the same each time the report is executed.
>how?
>tia,
>mcnewsxp

Take a look at the Tabledefs collection in the source database. It will have
entries for the essential systems tables, all with names starting with MSys; I
presume you want what's left over.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/For...-US/accessdev/
http://social.answers.microsoft.com/.../en-US/addbuz/
and see also http://www.utteraccess.com

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Import Excel File into Access DB where user can specify file name andcell range to import	ssa	Microsoft Access External Data	1	18th May 2011 01:18 AM
change first name last name to last name first name	Doris smith	Microsoft Excel Misc	3	25th Feb 2009 12:35 PM
how do I reveerse name order last name, first name to first name, last name	Don Smith	Microsoft Excel Discussion	9	29th Nov 2006 10:55 PM
Changing a list from last name, first name to first name, last name	zgall1	Microsoft Excel Misc	3	17th Feb 2006 12:49 AM
table name as same import file name	=?Utf-8?B?TSBMZWRkeQ==?=	Microsoft Access External Data	1	21st Apr 2004 12:08 AM