ODBC Connection and Excel Spread Sheet
-
Sorry to bother you with this question. I'm totally new to this and I don't know what I'm doing :) I want to use an Excel spread sheet as a database. Any ideas how to do it? I think I have to use ODBC but I have no idea how to write the appropriate connection string and how to write a query? I've been googling for some time but I cannot find any information on this topic. Where should I look?
-
Sorry to bother you with this question. I'm totally new to this and I don't know what I'm doing :) I want to use an Excel spread sheet as a database. Any ideas how to do it? I think I have to use ODBC but I have no idea how to write the appropriate connection string and how to write a query? I've been googling for some time but I cannot find any information on this topic. Where should I look?
Search codeproject for Excel ADO. It may be better to use Access if you can, then use Excel to pull updated data from the access db.
Blog Have I http:\\www.frankkerrigan.com
-
Search codeproject for Excel ADO. It may be better to use Access if you can, then use Excel to pull updated data from the access db.
Blog Have I http:\\www.frankkerrigan.com
Thank you for your advice. I've found some information that might be useful. I want to make an application that uses a simple database that does not need SQL server, Access or MS Office installed on the computer. I currently use Excel to do my work but I wan't to be able to do it without it.
-
Thank you for your advice. I've found some information that might be useful. I want to make an application that uses a simple database that does not need SQL server, Access or MS Office installed on the computer. I currently use Excel to do my work but I wan't to be able to do it without it.
You don't need MS access or office on a machine to use an access database with a website.
Blog Have I http:\\www.frankkerrigan.com
-
Thank you for your advice. I've found some information that might be useful. I want to make an application that uses a simple database that does not need SQL server, Access or MS Office installed on the computer. I currently use Excel to do my work but I wan't to be able to do it without it.
Using an access database is preferable to Excel, and you don't need Access or Office installed. But if you must use Excel, here is an example connection string for you: Provider=Microsoft.Jet.OLEDB.4.0;Data Source="Path\MyExcelFilename.xls";Extended Properties="Excel 8.0;HDR=NO;IMEX=1;ImportMixedTypes=Text" I can't remember what IMEX is, but HDR is whether the first row of data is a header row or not.
-
Using an access database is preferable to Excel, and you don't need Access or Office installed. But if you must use Excel, here is an example connection string for you: Provider=Microsoft.Jet.OLEDB.4.0;Data Source="Path\MyExcelFilename.xls";Extended Properties="Excel 8.0;HDR=NO;IMEX=1;ImportMixedTypes=Text" I can't remember what IMEX is, but HDR is whether the first row of data is a header row or not.
-
Thank you very much for your advice. I've found a sample on this site that seems as an excellent starting point. I'll think about the access database too but creating an sample access database (or anyone) does require MS Access?
I have not created Access databases fom code in a long time, but it can be done. I think you have to add a reference to ADOX library. Yes, here is a link http://www.freevbcode.com/ShowCode.asp?ID=5797[^] to an example.