How to import excel file

Xpert · Post by **Xpert** » Mon Jul 10, 2006 11:58 pm

Hi,

How to import excel file and need to convert excel file data into table. Thanks in advance.

chulett · Post by **chulett** » Tue Jul 11, 2006 12:26 am

Have you tried searching the forum? Asked and answered many (many) times.

vijayindukuri · Post by **vijayindukuri** » Tue Jul 11, 2006 12:30 am

Hello Xpert,
This has been posted many times ,try using a search use EXCEL as key word.
U can convert the xcel file into csv format and the load the data.

loveojha2 · Post by **loveojha2** » Tue Jul 11, 2006 12:36 am

You can use Microsoft's ODBC Driver for Excel for this.

But I would prefer to do it by converting it into the csv then using using the csv as a sequential file.

Xpert · Post by **Xpert** » Tue Jul 11, 2006 1:07 am

loveojha2 wrote:You can use Microsoft's ODBC Driver for Excel for this.

But I would prefer to do it by converting it into the csv then using using the csv as a sequential file.

Is there any other way, leaving this ODBC and Converting into CSV.

loveojha2 · Post by **loveojha2** » Tue Jul 11, 2006 3:36 am

Just open the xls document, and Do a Save As and save the file as a csv file. And its all done.

ray.wurlod · Post by **ray.wurlod** » Tue Jul 11, 2006 5:36 am

Xpert wrote:Is there any other way, leaving this ODBC and Converting into CSV.

There's always another way. You could, for example, read the XLS file directly and spend a fortune on Microsoft-savvy consultants who can interpret what each byte in the file means. Doesn't mean that the other ways are sensible! What's wrong with ODBC - a Microsoft standard being used to access a Microsoft product?