A
Andy Fish
ok, so after a few dead ends I have got this far:
1. using visual studio 2005, create a new blank windows forms project and
add a data source
2. create a new connection, select data source as "other" then select ".net
framework data provider for oledb"
3. select "microsoft jet 4.0 ole db provider"
4. enter file name, then under advanced, enter Excel 8.0;HDR=YES
5. click to test connection - works ok
6. ignore suggestion about coping the data file to the project (if I try to
do it, it just gives "unexpected error" afer 30 seconds of disk grinding)
7. back on the data source configuration wizard, I get as far as "choose
your database objects" and the screen just shows the message:
an error occurred while retrieving the information from the database
operation is not supported for this type of object
the xls file itself was created with excel 2003 and contains the data:
id, name, address
1, fred, reading
2, john, london
anyone got any clues? I thought i'd start off doing the simplest thing
possible then work up to something useful but I can't get seem to get off of
the start line at the moment.
TIA
Andy
1. using visual studio 2005, create a new blank windows forms project and
add a data source
2. create a new connection, select data source as "other" then select ".net
framework data provider for oledb"
3. select "microsoft jet 4.0 ole db provider"
4. enter file name, then under advanced, enter Excel 8.0;HDR=YES
5. click to test connection - works ok
6. ignore suggestion about coping the data file to the project (if I try to
do it, it just gives "unexpected error" afer 30 seconds of disk grinding)
7. back on the data source configuration wizard, I get as far as "choose
your database objects" and the screen just shows the message:
an error occurred while retrieving the information from the database
operation is not supported for this type of object
the xls file itself was created with excel 2003 and contains the data:
id, name, address
1, fred, reading
2, john, london
anyone got any clues? I thought i'd start off doing the simplest thing
possible then work up to something useful but I can't get seem to get off of
the start line at the moment.
TIA
Andy