Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Excel as my database
Hello all,
I need to use Excel as my database because my company needs to save the data in flat files. Can I define tables in Excel? Can I retrieve/update records matching set criteria from several tables? Can I use SQL? Thanks a lot, Rachel |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Excel as my database
Hi,
it's possible. But don't insert ou delete line or row, you will have to redefine the table. I already try with a access programm. "Rachel" a écrit dans le message de news: ... Hello all, I need to use Excel as my database because my company needs to save the data in flat files. Can I define tables in Excel? Can I retrieve/update records matching set criteria from several tables? Can I use SQL? Thanks a lot, Rachel |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Excel as my database
Hi
if you have this requirements you really should use a database. e.g. MS Access. Also what do you mean with 'has to save as flat file'? -- Regards Frank Kabel Frankfurt, Germany Rachel wrote: Hello all, I need to use Excel as my database because my company needs to save the data in flat files. Can I define tables in Excel? Can I retrieve/update records matching set criteria from several tables? Can I use SQL? Thanks a lot, Rachel |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Excel as my database
You can certainly use excel as a database, and read/write/update etc using
ADO, but this requires a fair bit of automation. I think you can access SQL databases, but I haven't got that far yet. Go to the VBE Editor, then the VBA Help and search on ADO. Office 200 onwards I believe Joe "Rachel" wrote in message om... Hello all, I need to use Excel as my database because my company needs to save the data in flat files. Can I define tables in Excel? Can I retrieve/update records matching set criteria from several tables? Can I use SQL? Thanks a lot, Rachel ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 100,000 Newsgroups ---= East/West-Coast Server Farms - Total Privacy via Encryption =--- |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Excel as my database
"Joe90" wrote ...
You can certainly use excel as a database, and read/write/update etc using ADO You can't DELETE using SQL (you can SELECT..INTO a new table and DROP TABLE on the original but this has limits <g). There are other missing features e.g. constraints, indexes, reliable data typing, declarative referential integrity, user accounts for security, etc. Jamie. -- |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Excel as my database
"Joe90" wrote ...
You can certainly use excel as a database, and read/write/update etc using ADO You can't DELETE using SQL (you can SELECT..INTO a new table and DROP TABLE on the original but this has limits <g). There are other missing features e.g. constraints, indexes, reliable data typing, declarative referential integrity, user accounts for security, etc. Jamie. -- |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Excel as my database
"Joe90" wrote ...
You can certainly use excel as a database, and read/write/update etc using ADO You can't DELETE using SQL (you can SELECT..INTO a new table and DROP TABLE on the original but this has limits <g). There are other missing features e.g. constraints, indexes, reliable data typing, declarative referential integrity, user accounts for security, etc. Jamie. -- |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Excel as my database
"Frank Kabel" wrote ...
if you have this requirements you really should use a database. e.g. MS Access. MS Access/Jet would seem to be the way to go. A .mdb file would meet the requirements for a flat file (it only becomes a relational database when coupled with the Jet SQL engine). Jamie. -- |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Excel as my database
Hi Jamie
I also would assume the company probably is not that clear what they mean with 'flat file'. I don't think they want a kind of VSAM data structure (at least I hope they don't want it...) -- Regards Frank Kabel Frankfurt, Germany Jamie Collins wrote: "Frank Kabel" wrote ... if you have this requirements you really should use a database. e.g. MS Access. MS Access/Jet would seem to be the way to go. A .mdb file would meet the requirements for a flat file (it only becomes a relational database when coupled with the Jet SQL engine). Jamie. |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Excel as my database
Jamie,
I really don't understand... If I use VBA or an exteranl program that sends queries to the Excel database through ODBC, won't it be like any other database? Can you detail more the missing features of Excel as a database? Thanks a lot |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Excel as my database
|
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Excel as my database
Thanks a lot :-)
|
#13
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Excel as my database
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update Excel Database via Access Main Database with a script | New Users to Excel | |||
Convert Excel database to dBASE database? | Excel Discussion (Misc queries) | |||
database query not showing foxpro database How I import data | New Users to Excel | |||
How to make reference to database and if true copy from database? | Excel Discussion (Misc queries) | |||
Moved database, how do I change link to the database in excel | Excel Discussion (Misc queries) |