July 6, 2010 at 6:51 pm
Hi:
I am brand new to SQL Server, and have a seemingly simple set of tasks that I can't figure out....and I'm hoping someone out there can help walk me through this......I am working w/ SQL Server 2005 and SQL Server Management Studio Express
Step #1 - I need to set up the database described in the attached support document and import the data file provided......I have the noted scripts (#1 setting up the database, #2 creating the tables, #3 creating the indexes) plus the import data BAT file........no problem running the first script, but the "create tables" script keeps running separately and setting the tables up under "System Databases/master" rather than in my target (TX_SOR) database - how do I run the second and third scripts and the data import so everything merges with my new database?
Step #2 -- I am going to need to build a few queries merging data from several of these tables, and ultimately export these data into a couple of merged Access tables......the SQL query interface looks very scary to me, though, and I would be much more comfortable if I could build those queries in Access, where I have more of a comfort zone........so my first preference would be to export this entire SQL database (along with tables and indexes) into Access...are there easy steps to make this happen? if not, I will probably be back on this board with some query building questions.......
Thanks so much for anyone who can help.
Andy
July 7, 2010 at 6:40 am
Thanks, Stewart.....
Just so I'm clear - so I should be able to set up a blank Access database, then link to the SQL database via ODBC, run my queries in Access, and then save those queries in Access - i.e. use Access as my front end and not need to mess with designing queries in SQL.....the raw data remains in the SQL database.....do I have that right?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply