• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 157
  • Last Modified:

Can I know the name of a table inside an Access (MDB) or Excel (XLS) file?

Hi! I have an app which uses an adoDataSet to connect to an Excel or an Access file (choosen by user), but I wanna now if there's a way to retrieve the sheet's (XLS) name, or the table's name (MDB).
Tried to do it through property CommandText, making a reference to it as an array, but obviously, it was wrong.

I'll appreciate any help =)
Alex
0
atirado
Asked:
atirado
1 Solution
 
Amir AzhdariCommented:
hi ,
if i don't misunderstood , you wanna get tables name in a MDB file if so , use an adoconnection , set the 'adoconnection.connectionstring' and set your adodataset's connection to the adoconnection , place a memo and then try this code :

adoconnection1.GetTableNames(memo1.Lines,False);

let me know if you have any prob.

Regards
Azhdari
0
 
atiradoAuthor Commented:
Thanks a lot, Azhdari! It worked out just perfectly! =)

Greetings from MX (H)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now