How to get the table name of the uploaded database in access 2010?

Question

1.00/5 (1 vote)

See more:

Hi,

I have a access tool in which i can upload a Access database.

I use the below method to import the file.

DoCmd.TransferDatabase acImport, "Microsoft Access", strFilePath, acTable, strFileName, "Table" ".

Here strFileName is the filename of the uploaded file.
But instedd of filename i need the TableName inside that filename.

So please can anyone tell me how to get the table name of an uploaded file?

Posted 17-Jan-13 19:52pm

gokulsjce

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

gokulsjce · Accepted Answer · 2013-01-17T21:47:00

Solution 1

Hi ,

The solution is

VB

Dim db      As DAO.Database
Dim tdf     As DAO.TableDef
Set db = OpenDatabase(strDBPath)
strTableName=db.TableDefs(0).Name
DoCmd.TransferDatabase acImport, "Microsoft Access", strDBPath, acTable,strTableName, "TempTable"  

db.Close

Posted 17-Jan-13 21:47pm

gokulsjce

How to get the table name of the uploaded database in access 2010?

1 solution

Solution 1

Add your solution here

Preview 0

How to get the table name of the uploaded database in access 2010?

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us