I am trying to get and *.xls file. I have Window Xp as Os. In ODBC driver i hv set up excel drive also and loaded one worksheet on it. But still i am not able to load that in DS table defination.
Vaishali
excel files
Moderators: chulett, rschirm, roy
Curious if you've tried searching the forum for the keywords 'excel' and 'ODBC'? There are quite a number of posts on the subject, perhaps an answer to your question lies there somewhere.
Either that or explain in more detail the problem you are having.
Either that or explain in more detail the problem you are having.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You need to know two tricks.
One is that the data in the work sheets must be in columnar format with column headings (these become the "column names") in the imported "table definition".
The second is that Excel ODBC driver reports worksheet names as system table names, so you have to check the "System Tables" check box during the import process.
One is that the data in the work sheets must be in columnar format with column headings (these become the "column names") in the imported "table definition".
The second is that Excel ODBC driver reports worksheet names as system table names, so you have to check the "System Tables" check box during the import process.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.