For my more computer-saavy friends: I need an easy way to import an Excel table into a SQL database. I know this is possible. I just don’t know how. Help!
Update: Ok, hopefully this is more accurate. What I really need is some sort of SQL database management software. This is my first time working with databases. I understand the concept — tables and stuff. Is there something that will let me manage the tables similar to Excel? Like a database-connected version of Excel? Am I sounding crazy? If that doesn’t exist, I just want a way to upload an Excel table and merge it into the database.
Hmmm, I’ve done the opposite. 😉
Tab or comma-delimited text file?
Sarah, I’m confused; that almost sounds like you want to use Access.
Maybe I do, Barbara. Honestly I have no idea. This is my first time dealing with databases.
I was told by someone else that Enterprise Manager is a good tool, but apparently it’s not made anymore….replaced with SQL Server?
need to know your target database application. Access? mySQL? SQLServer?
Basically, it is easy if you save your Excel file as a comma-delimited text file as Scott says. This is SaveAs filename.csv
Vic — I think that’s the problem — I have no target application. Currently I just use the web interface. I think I want to use SQL Server, but I’m confused as to how…
Since this is your first time creating and maintaining a database I would personally recommend that you use Access. It’s got a lot of wizards that can make things a little easier (if you want to use them), and it can handle quite a bit of data and numerous tables. I believe Access 2003 costs ~$220 to buy directly from Microsoft, but I’d cruise Ebay or online for a better deal.
I’ve used SQL Server before and really enjoyed it, but while I don’t know the exact cost of it I believe it’s pretty expensive. All in all, if this is just a casual/personal project I’d stick with Access.
Sarah, I’m out of pocket this afternoon, and this evening. I’ll be home after 8pm or so from playing trumpet can can help you out then by phone if you want.
At least I can offer to help….that doesn’t mean I’ll actually *be* any help – LOL! Just shoot me an email (or do you have my cell phone #?) if I can help out.
Could you possibly give a few more details, like what this is for, what you’re trying to do? Also, someone asked which database software you’re using… that’s not decided yet?
Hey Sarah – not sure what you’re trying to do, but this link shows a way to run SQL commands on data in Excel. It has come in handy for me.
http://www.expresscomputeronline.com/20031020/techspace01.shtml