Jump to content

Excel File As Database


Recommended Posts

Hi,

Instead of using the SQL database, does anyone know if it is possible to connect the Unilogic to an Microsoft Excel file? I would like to generate an easy database on the Excel spreadsheet and put it on SD card or some other places, and then connect the Unilogic to the spreadsheet to get the data.

 

Thanks,

Charls 

Link to comment
Share on other sites

We’ve found the best approach is to just save a data table to a UDT file and then use the converter to toss it into Excel.  
 

You can save it to a csv file but you have to thoughtful of how much time it takes to write to the csv file.  

Link to comment
Share on other sites

I have accomplished this a couple different ways:

1. Put the data table on a webserver page so you can connect and edit data remotely. 

 2. Convert UDT to .csv then FTP that to your network folder.  Open in excel, edit, save as .csv, put back in network folder, Then FTP receive from the PLC (power up or button etc). 

3. SQL to/from SQL database.

SD card would be my last choice, you can even just use a FTP client like filezilla and "manually" grab it off the PLC to edit then put it back.

Only issue I have is converting from .csv into excel, takes to many clicks/keystrokes so I normally just edit the raw .csv in notepad.

 

File size could be an issue but some tables have 500-1000 rows of 19 columns and do not miss a beat. 

 

-Swervomotor

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...