Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
 Posted - 2006-10-02 : 21:48:57
|
| I have a access 2000 db, and only MS ACCESS 2000 not 2003. I am having a hell of a time tring to import the databases to sql server express 2005. When I use the Upsize wizard in access 2000, I get a error that says "OVERFLOW" and that's it. I can setup the access file as a linked server, but then what should I do, is there a query I can run that will re-create the access db as a sql server 2005 express? This is one of those issues I thought was going to take 10 minutes to fix, and I'm going on about 4 hours, and getting really frustrated. Any help would be appriciated..Thanks |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-03 : 01:03:27
|
| Overflow most often means that you are trying to import numbers and the target table in SQL does not have the appropriate size for holding the number from the source table.Read about DATA TYPES in BOOKS ONLINE and figure out which data type that is right for you.Also take a look at the VARCHAR columns to see if they are sized properly.Peter LarssonHelsingborg, Sweden |
 |
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2006-10-03 : 01:22:12
|
| ??? I am not importing to a target table, or db. I am having the upsize wizard create it. I am still confused on where to begin. |
|
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2006-10-03 : 02:01:21
|
| The issue was that I needed to apply sp3 to office 2000. It resolved the issue. |
|
|
|
|
|
|
AHHHH MSAccess to sql server express