Another Lame Access to SQL question

[ribhead]

By my own admission I am a super newby so please excuse the ignorance. I have looked for quite a while in this forum and some others as well and I can't find a step by step on how to convert my Access 2000 db to a SQL db. I have been told by my IT guy I need an ODBC connection, do I need to set up a pass through query with a connection string?. I've read so many things I think I'm confusing myself. Here is what I do know. 1.My company has SQL2000 2. I know the name of the server it's on 3. I know the password. Can anyone tell me where I can read about setting this stuff up because I'm going crazy trying to figure this out on my own.

Thanks
The rib

Quit saying hot water heater! Nobody wants to heat hot water.

 

[dbomrrsm]

ribhead

Here is a good start - good luck !

Thread faq183-2935

[blue]DBomrrsm[/blue]

 

[ribhead]

Hi Db

I've looked at that one but can't open the link.






The rib


Quit saying hot water heater! Nobody wants to heat hot water.

 

[dbomrrsm]

Link works for me but anyways go to search and search FAQ's for:

Convert Access to SQL Server

where you should find this link.

[blue]DBomrrsm[/blue]

 

[LLBP]

I have upsized Access 2000 dbs to SQL 2000 via the Upsize Wizard in Access. Be advised, I couldn't do it using Office 2000. I was able to using Office XP though. It is a step by step wizard, really easy. It links all of the tables in Access to the SQL database so the Access db works exactly the same. You can upsize all or select certain tables.

-Brent

 

[ribhead]

Brent,

I use Windows 2000 so can't do it via the Upsize Wizard. I'm glad you couldn't do it either but it was driving me crazy.




rib
or P-)

Bartender:Hey aren't you that rope I threw out an hour ago?

Rope:No, I'm afraid knot.

 

[craigfw]

Hey Ribhead,

I have just started working with SQL Server after a 3 year break and I'm feeling slow. One of the first things that I had to do was import two Access db's with no relations and merge them by hand after migrating them into a Excel Spreadsheet, strip out all the formatting in the columms, save the spreadsheet as a *.txt file, and then bcp the rows into a new table that I created using DBArtisan. This was a real pain, but if you need to go this degerate route, it does work. I then created and ID column (int, not null, seed 1, incriment 1, and this solved the problem for now. I know it's ugly, but it worked....

Craig