MS Excel "Database"
-
Hi, can i use excel "almost" like a database? i thinks on using a sheet like table and workbook like database,validations fine (don´t need key: i don´t get many errors from there) My problem is the sql statements, can i query it(excel data)? i don´t know how, i think also sql statement in c# don´t work in this case. must i use xml? :(( (no code needed) thanks :-D
nelsonpaixao@yahoo.com.br trying to help & get help
-
Hi, can i use excel "almost" like a database? i thinks on using a sheet like table and workbook like database,validations fine (don´t need key: i don´t get many errors from there) My problem is the sql statements, can i query it(excel data)? i don´t know how, i think also sql statement in c# don´t work in this case. must i use xml? :(( (no code needed) thanks :-D
nelsonpaixao@yahoo.com.br trying to help & get help
-
Hi, can i use excel "almost" like a database? i thinks on using a sheet like table and workbook like database,validations fine (don´t need key: i don´t get many errors from there) My problem is the sql statements, can i query it(excel data)? i don´t know how, i think also sql statement in c# don´t work in this case. must i use xml? :(( (no code needed) thanks :-D
nelsonpaixao@yahoo.com.br trying to help & get help
Hello, You can use excel sheet as an Database, and you can also query it like regular Access or Sql Database.you can use oledb connection to excel file from your vb.net or c# application. Use the connection string below, "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=XLFile.XLS; Extended Properties="Excel 8.0; HDR=No;"