Database upload by Excel file

I'm not sure where this question should fit, we are using LENEL OnGuard ET software by the www.lenel.com company, the problem that we need to upload the system database with Excel sheet data to avoid entering each record manually. I wonder if there is any way to do so. It will save us lots of time.
laffanAsked:
Who is Participating?
 
TheMekConnect With a Mentor Commented:
On their site they claim to have an open architecture: OnGuard can bidirectionally exchange data with any ODBC compliant system.
So it should be possible to get data from Excel into the OnGuard system...but to know how you'll need more information from their side. How is their datastructure organized and how is it stored? Are there interfaces at hand to import data etc.

Cheers,
   Erwin
0
 
Jeffr0Connect With a Mentor Commented:
If you use Access, you can link the tables in just like any other ODBC datasource.

(See "File | Get External Data | Link Tables")

You can link the spreadsheet into the Access database the same way-- then all you have to do is write an append query from the Excel sheet to the OnGuard tables.
0
All Courses

From novice to tech pro — start learning today.