| Author |
 Topic Search  Topic Options
|
Gullanian 
Senior Member
Joined: 04 January 2002
Location: England
Status: Offline
Points: 4373
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Access - SQL
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
|
 |
Gullanian
Senior Member
Joined: 04 January 2002
Location: England
Status: Offline
Points: 4373
|
Post Options
Thanks(0)
Quote Reply
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
|
|
Gullanian
Senior Member
Joined: 04 January 2002
Location: England
Status: Offline
Points: 4373
|
Post Options
Thanks(0)
Quote Reply
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!
|
|
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Post Options
Thanks(0)
Quote Reply
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..
|
|
|
|
ljamal
Mod Builder Group
Joined: 16 April 2003
Status: Offline
Points: 888
|
Post Options
Thanks(0)
Quote Reply
Posted: 06 June 2003 at 7:18pm |
|
Why not use the DTS Import/Export functionality of SQL Server to import the Access tables?
|
|
|
|
MorningZ
Senior Member
Joined: 06 May 2002
Location: United States
Status: Offline
Points: 1793
|
Post Options
Thanks(0)
Quote Reply
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
|
|
TYSON
Groupie
Joined: 18 August 2002
Location: Australia
Status: Offline
Points: 142
|
Post Options
Thanks(0)
Quote Reply
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)
|
|
|
|
