Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 692
  • Last Modified:

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.
0
laffan
Asked:
laffan
2 Solutions
 
TheMekCommented:
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
 
Jeffr0Commented:
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
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 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

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