saving MS access table to the pendrive

[user_1]

Hi All....

I need an option to save a table from MSAccess database to a pendrive.

Is it possible to code for this in labview?

Thanks in Advance

[Eric A.]

Hi,
Yes LabVIEW has the capability to do this.  You might want to check into using the database connectivity toolkit to get the table from access but the file. Saving portion of the code is a basic function of LabVIEW.  I hope this helps.

[user_1]

Thank yo so much for the reply sir.

I am doubtfull on the following scenario.

Is it possible to save to the pendrive in the access-table format?

I used database connectivity tool sets in my applications.but i couuldnt find any tools to facilitate this.

Thanks once again

[Dennis_Knutson]

Why are you having doubts? Did you actually try to save to a pen drive? The pen drive appears to the OS as just another drive and if there is enough space, it should be no different than saving to a local or network drive. It should be just a matter of specifying a different drive letter. No special tools are required are required if you decide to write to a network drive instead of a local drive are there?

[user_1]

Thanks 4 the reply.

My doubt is not related to saving to pendrive.

I have done operations like reading from pendrive.

I am confused on how to save the file.

Is it only by using the file dialogue box and changing the ok button to save.

I have to save a table say tb_emp which is residing on C:\employee.mdb. i have to copy this  into some other location(say to pendrive)

how do i do that?

[user_1]

I got one way to do this by using the option of copy under file i/o

Its able to copy a file from source to destination.

If i want to copy c:\employee.mdb to d:(or any other drive) its possible.

But if i want to copy only a single table from the employee.mdb how do i proceed?

[Dennis_Knutson]

Now I understand the confusion. You don't want to save to an existing db, you want to create a new one with a single table from another db. Amazing how much a few details can change the whole problem. I don't know if the database toolkit has a function to create a whole new database. I don't think there is a SQL command for it either. For an exisiting database, you can create a new table.

With just SQL commands, you might want to have an empty database with either a blank table or no tables at all. If it's always the same table, then it's simpler to have a an existing table with no entries. Copy this to the pendrive and then you should be able to do a SELECT of the main database to get the data and then write it to the pendrive's database with the INSERT command.

If you want to be more tied to Access, then you might be able to use the ActiveX interface to Access.

[user_1]

Thanks again.

I just copied the entire database to the destination path(or drive) as there is no way to create a new database using query or labviewtools(thought if needed can delete the unwanted tables from the copied path...even its not a good method i have to do like that).

I never worked with activex.Can u pls suggest me some materias that explain the concepts of activex control(staring from the basic)

Thanks once again

[Eric A.]

Hi, Check out these basic links on ActiveX.

Wikipedia

NI Developer Zone

This should get you started learning about ActiveX.  You should also know that some programs can be used as ActiveX controls.