Excel and SQL Jan22 '06
Feedback
# (2 of 8): Matthom
3 days, 5 hours after the fact. (Wed 25 Jan 2006, 3:55 PM CST)
True to the point, Jennifer. Good idea. IF I was using Access as my database, then I probably wouldn't need Excel that much.
But I'm referring to a MySQL database, in which you'd have to either use a GUI tool, or the command-line, in order to enter queries.
I probably didn't specify "MySQL" in the entry, so my bad.
# (3 of 8): Jennifer Grucza » jennifergrucza.com
4 days, 2 hours after the fact. (Thu 26 Jan 2006, 12:02 PM CST)
No, I'm saying you can link Access to non-Access databases. For instance, I've done it at work with Postgres databases.
See this page for instructions on how you can do it (well, if you're using Windows - not sure how it would work on a Mac).
# (4 of 8): Matthom
4 days, 3 hours after the fact. (Thu 26 Jan 2006, 1:08 PM CST)
Well, that's very interesting... thanks for the reference. I didn't know you could do that.
# (5 of 8): Jennifer Grucza » jennifergrucza.com
4 days, 7 hours after the fact. (Thu 26 Jan 2006, 5:18 PM CST)
Hope it's helpful. :)
# (6 of 8): Andy » paininthetech.com
5 days, 1 hour after the fact. (Fri 27 Jan 2006, 11:39 AM CST)
We also used Access as a front-end to SQL Server at a previous employer, which worked quite well for GUI management and viewing of a SQL Server 2000 DB. PS- when you move the focus away from the text boxes below, it deletes anything you entered, which is annoying. Not sure if you want to dig into that, or if it is a Wordpress thing...
# (7 of 8): Matthom
5 days, 1 hour after the fact. (Fri 27 Jan 2006, 11:50 AM CST)
when you move the focus away from the text boxes below, it deletes anything you entered
Thanks for pointing that out. If you've saved your personal info as a cookie, in the past, it will always re-populate those fields, with that cookie info - whenever you apply focus to the main feedback textarea.
This is undoubtably a bug, on my part - but it's a "home-made" system, so that's what I get. ;)
# (8 of 8): Roberto Galvan
2 years, 8 months after the fact. (Tue 30 Sep 2008, 2:00 PM CST)
And how do i conect to the data base using excel?, i need to do it whitout using a macro.
RSS feed for comments on this post
Leave feedback
is published and produced by Matt Thommes - an independent publishing enthusiast, mobile blogger, content creator, informative writer, web developer from Chicago.
Never one to conform, Matt intends to promote the effect the web has on our lives, in an effort to intensify, instruct, and clarify all that is happening around us.
As a web developer, responsible for everything from the front-end design, to the back-end database - I can’t tell you how useful Microsoft Excel is, in combination with SQL.
You are at the feedback permalink page for: Excel and SQL
# (1 of 8): Jennifer Grucza » jennifergrucza.com
3 days, 3 hours after the fact. (Wed 25 Jan 2006, 1:37 PM CST)
What about using Access? You can link Access directly to your database (using ODBC), so that changes made in Access are saved directly to the database.