Excel upload in columns of tables

Author Topic
fsdf sdfsdf
Member

Joined: 27 Apr 2005
Country:
Posts: 1

Posted: 27 Apr 2005 06:32:13

Hi,

i want to upload an excel sheet in respective columns of database table.

For example, i am having 24 cols in table1 naming like: jan1,jan2,feb1,feb2 ,mar1,mar2,.......dec1,dec2

And i am having Excel sheet with 12 cols for 12 months , like Jan1,feb1, Mar1,Apr1,....Dec1

This Jan1 from Excel Sheet should go to table1.Jan1 of database and Feb1 from ExcelSheet should go to table1.Feb1 etc.

How to?

Hi,

i want to upload an excel sheet in respective columns of database table.

For example, i am having 24 cols in table1 naming like: jan1,jan2,feb1,feb2 ,mar1,mar2,.......dec1,dec2

And i am having Excel sheet with 12 cols for 12 months , like Jan1,feb1, Mar1,Apr1,....Dec1

This Jan1 from Excel Sheet should go to table1.Jan1 of database and Feb1 from ExcelSheet should go to table1.Feb1 etc.

How to?

Follow us on twitter Subscribe to our RSS feed
Activate your free membership today | Login | Currency