sql query and ms excel through vb.net

[Princess]

hi
i m facing 2 problems:
1. how to create and manipulate excel worksheet/book through vb.net code


2. i've written a piece of code .there is a sql query-

"SELECT * FROM table1 NATURAL INNER JOIN table2 "

oledbconnection is used . back end is ms access.

problem is i get oledb exception error on executing this.

how can these 2 problems be solved.

thank you

 

[cjard]

1. did you google for the wrong thing?
http://www.google.co.uk/search?sour...GLG:2006-25,GGLG:en&q=vb.net+excel+automation

2. ensure access supports the NATURAL INNER JOIN syntax. if it doesnt, then create the join explicitly (join the twotables on whichever names are equal in both)
SELECT * FROM a INNER JOIN b ON (a.id = b.id)