XLS to Access to sql, all data skipped by Upsizing Wizard 1

[TexARC]

I used to do db design in relational dbs many years ago, so I was volunteered to do this project for the archery organization. I'm way over my head. I currently have around 2000 archer records in a simple spreadsheet.

Have migrated the spreadsheet contents into both a flatfile Access database, as well as a normalized database in Access 2003, where consistent values are in related tables("Indoors/Outdoor", "Male/Female", etc.) with ID Keys in all tables. Not a very big database, and one that will not have a lot of changes each year.

My goal is to create an online searchable database using Web Studio. All the tutorials use sql databases, and since this is a learn-as-i-go novice effort, I want to use sql.

Using the upsizing wizard creates all of the tables in sql, but no data is transferred- when I view the data using Web studio 2005 nothing but NULL in each field. All field names in access are simple ("Archer", "Gender", "Distance", "Round", etc.) and seem to make the trip into the sql database tables. Each record/row has around 12 fields, and I can't afford to sit down and type all of them into the empty sql database that the upsizing wizard created.

The only tips I can find say to forget the wiz and use DTS, but I can't find out how to use DTS since I don't have SQL 2005, just the server.

This is likely an incredibly basic and easy task to accomplish, but I can't get the data moved from Access 2005 into an SQL file format. Anybody willing to help with such rudimentary problems? Will gladly trade for archery instruction!


High Performance Coach, Level III, USA Archery
webmaster, Texas State Archery Association
(

http://www.texasarchery.org)

 

[unclerico]

since I don't have SQL 2005, just the server

Can you clerify what you mean here??

 

[TexARC]

I have "Microsoft SQL Server 2005" as a folder on my programs list, and SQLExpress 9.0.2047 running as the server instance, but other than configuration tools there is nothing in the folder. Visual Studio lets me create a data connection so I'm reasonably certain that the sql server is running.

Apparently everyone in the world that knows anything about sql doesn't think to explain how to actually use it, where and how to invoke it.
For example, tutorials describing how to use SQL will tell you "type SELECT "column_name" FROM "table_name"" as an example, but never say where the heck to type this command!(what program?) I've yet to find a getting started tutorial that is as dumbed-down as I am.
My best guess to date is that you have to have another program to act as the front end, such as Access.

High Performance Coach, Level III, USA Archery
webmaster, Texas State Archery Association
(

http://www.texasarchery.org)

 

[unclerico]

yep, you could use Access and link tables in an run some queries through that. SQL Express is the free version of SQL Server 2005 and all it really is is the DB Engine. I haven't had an opportunity to even look at SQL 2005 so the only thing I can tell you is that maybe you should post this in either forum183 or forum962