Excel data import

**MarkoSan** · 21st May 2010, 11:04

Does anyone has guidelines how to import excel file into database? Supose, column names in database and in excel are identical.

Sincerely,
Marko

**tbscope** · 21st May 2010, 11:21

Get an activex excel object.
Use it to get data from your excel files.
Insert the data in your database.

This will only work on Windows of course.

**MarkoSan** · 21st May 2010, 11:27

So there is no way to import data platform independent?

**tbscope** · 21st May 2010, 11:31

Sure there is, save your excel files in a standard xml or csv file for example

Thread: Excel data import