export large MS Access database files to labview

[DavidJCrawford]

You are welcome to try this example in LV8.2. It uses DAO to export a table from Northwind.

You will need to adjust for your own system.

David

Message Edited by David Crawford on 09-20-2006 05:09 PM

[DSMarcinko]

David

Thank You!

I'll give this a try.

[DSMarcinko]

David,

Do you know a method to eliminate the security warning when opening an access database?

[DavidJCrawford]

I have to admit I didn't see that when I run that example with Access 2003. Perhaps its something you can switch off in the Options of MS Access.

David

[DSMarcinko]

David,

Unfortunately it is not something I can switch off w/o creating digital signature and distributing to all users.

I've been attempting to utilize the technique in the attached vi. This one is setting up a connection and uses a ";Persist Security Info=False" string to bypass the security prompt. Take a look and see if you think there would be a way to shutdown the security prompt prior to opening and exporting the file. I'll welcome any ideas

Thanks

[DavidJCrawford]

I honestly don't know. What does the security dialog look like? Can you post an image?

I would need an example .mdb to let see what you are seeing and then we could try and see if there is a work around.

I won't be around after Fri for another week so if you could post before then I might get a chance to help you out.

How did you get on with the table export VI? Did it work for you?

David

[DSMarcinko]

David,

Table export worked great. Security message is caused by access security settings being set to Med or High or there is no digital signature associated with the database.

I've found some information at Microsoft that provides a method to disable this warning but I don't know how to apply this method in LabView. Maybe you could take a look.

http://office.microsoft.com/en-au/assistance/HP010379431033.aspx

view the last warning " security warning interrupts .....automated scripts"

Thanks

If you don't get to it this week, I'll still be here when you return

[dan_u]

jdam,
I think it's also possible to export data from a DB to a file using SQL. You could just execute a SQL query with the DB tools VIs (which I think you already used).
I don't have Access but the SQL command should look somewhat like:
SELECT * INTO OUTFILE "filepath.txt" FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY "\n" FROM tabelle WHERE field = value;
I think the correct syntax should be explained in the Access help.

Good luck
Daniel

[DSMarcinko]

David,

NI support team helped with the security setting in access. I needed to add a property node and set auto security to 1 (Low). vi attached.

Now I have another issue with the text transfer. The number fields in the data are transferring with two decimal place percision. The database contains up to 6.  I'd like to be able to open the database, convert all fields to text, perform TransferText and close the database w/o saving the changes. I think I should be able to perform this with the DoCmd but don't have any idea how to use the different methods. I've tried manually exporting the data as spreadsheet, but it only exports 65K lines (Excel limitation). I've been searching for reference documentation on the method and property commands, but don't know where to look on the internet. Do you have a good source of ActiveX commands available to use in access?

Any help is appreciated.

Dave