Database Discussion - Access

Print Page | Close Window

Access - SQL

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=3334
Printed Date: 28 March 2026 at 12:37pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Access - SQL

Posted By: Gullanian
Subject: Access - SQL
Date Posted: 06 June 2003 at 6:03pm

Anyone know how to import and access database into an SQL server, or copy tables over any other way? I got over 40 to do, its gonna take too long to manualy type them out

Replies:

Posted By: Gullanian
Date Posted: 06 June 2003 at 6:16pm

ive managed to export all tables as text files, followed a tutorial to import them to an SQL database, however it all looks ok, says its done but tables dont appear in enterprise manager

Posted By: Gullanian
Date Posted: 06 June 2003 at 6:41pm

when I upsize, it says 'Overflow'

the acces db is not large at all, only 1 or two meg!

Posted By: michael
Date Posted: 06 June 2003 at 7:11pm

Overflow means you are putting to large into too small. So basically trying to put memo content into a varchar field will give you a overflow or putting doubles into integers... Make sure the field types are set correctly. I would create the SQL tables with the script and then do an export or bulk import..

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: ljamal
Date Posted: 06 June 2003 at 7:18pm

Why not use the DTS Import/Export functionality of SQL Server to import the Access tables?

-------------
L. Jamal Walton

http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming

Posted By: MorningZ
Date Posted: 07 June 2003 at 12:02am

yeah, why do the text file thing

simply click on the DB in Enterprise Manager, select "All tasks", "import data" and follow the wizard

super easy stuff

-------------
Contribute to the working anarchy we fondly call the Internet

Posted By: TYSON
Date Posted: 07 June 2003 at 4:06am

"OverFlow" is a bug in access, i believe updating to the latest service pack for your version will fix the error.(assuming your not using Access 97)

-------------
http://www.fuo-motorsports.com/ - http://www.fuo-motorsports.com/