Experts Exchange connects you with the people and services you need so you can get back to work.

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.

laffan

Asked: 2004-04-21

Advertise Here

Databases

2 Solutions

LVL 5

TheMekCommented: 2004-04-21

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

LVL 2

Jeffr0Commented: 2004-04-21

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.

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.

Database upload by Excel file

Join & Write a Comment Already a member? Login.

Featured Post