PDA

View Full Version : 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