Want to connect Excel sheet to other files worldwide

[DEvOTeEL]

READER_1_1_1> DBG_21438 Reader: Source is [Romania:Romania], user [PMNullUser]. I will try to connect to an excel workbook with different country sheets containing data, which I want to load into our DWH. Now I'm getting the following error :
READER_1_1_1> Fri Dec 03 09:29:24 2004
READER_1_1_1> RR_4036 Error connecting to database [ [Microsoft][ODBC Driver
Manager] Data source name not found and no default driver specified Database
driver error... Function Name : Connect Database driver error... Function
Name : Connect Database Error: Failed to connect to database using user
[PMNullUser] and connection string [Romania:Romania].].
READER_1_1_1> Fri Dec 03 09:29:24 2004
READER_1_1_1> BLKR_16001 Error connecting to database...
MASTER> PETL_24020
Any help possible or do I have to export all sheets to single .csv files ?

[Gania]

I a not able to understand what you are trying to do. I think there is no easy way to do this. You can manage the same through SQL but it is really not easy. You will need some addtional support for the same. Try to find some solution on office help.

[Alfons]

I had did this before and I think there are some thing that will help you. Just go into the Excel menu, Data, External Data. There are SEVERAL technique, the first basic asssez that does not really do the sorting. (Import device of data) And the other that I have chosen is to create a query. Before choosing this technique, you must create an ODBC link. For ODBC go in Control Panel > Administaration Tools > Data Sources (ODBC). In my case my db was on a remote server and my database is in sql db then click tab: Data Sources and Add System. A list displays all go down to choose SQL Server, click finish. follow the wizard and all should go well. Now in Excel go to the menu > Data > External Data > create a query. You can simpkly choose your ODBC link and choose your table and your field.