Microsoft SQL Server
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community ForumsDatabasesMicrosoft SQL Server

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old April 20th, 2006, 12:00 AM
shigehiro shigehiro is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Apr 2006
Posts: 2 shigehiro User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 39 m 39 sec
Reputation Power: 0
Help: 'Data Overflow' error while exporting [from Ms Access] to Ms SQL 2000

hi there,

I would like to export tables in my existing Ms Access database to Ms SQL 2000 database...

However, for tables which have 'date/time' data type in Ms Access... would give me an error message : "(<table_name>, DBTYPE_DBTIMESTAMP), status 6ata overflow)".

Does anyone know how to solve this problem? What should I do to export date/time field correctly to Ms SQL without overflwo error?

Help is much appreciated. Thanks...

Reply With Quote
  #2  
Old April 20th, 2006, 09:03 AM
avarga82 avarga82 is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Apr 2006
Posts: 1 avarga82 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 6 m 21 sec
Reputation Power: 0
Hi there,

The reason you are getting that error is because you have a date in your Access table that is either too small or too large for the SQL data type. The first thing to try is setting the datatype of your SQL field to DateTime as opposed to SmallDateTime, as this allows for a larger date range. Secondly, manually check the smallest and largest dates in your Access table before tranferring. Look for erroneous dates such as 1/1/199, as this is probably just a data entry error. Change the value or delete the records.

Reply With Quote
  #3  
Old April 21st, 2006, 06:51 AM
shigehiro shigehiro is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Apr 2006
Posts: 2 shigehiro User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 39 m 39 sec
Reputation Power: 0
thanks for da help.. ll go and try it out...

Reply With Quote
  #4  
Old September 19th, 2009, 12:54 PM
AndyCODE AndyCODE is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Sep 2009
Posts: 1 AndyCODE User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 17 m 12 sec
Reputation Power: 0
Conversion 'short time fmt' (in MSAccess) to appr. SQL Server column

Despite problem solved (?) long time ago, decided to give an advice for future users who use SQL Server 2000 and tryin` to export data from MSAccess mdb...

To convert MSAccess`s short format date/time columns` data to SQLServer format without errors simply select 'datetime' in 'Mappings' (see Import and Export Data application options) - it works ok.

Timestamp is for DATE, such as yyyy.mm.dd hh:mm:ss, and SmallDateTime is for yyyy.mm.dd (it`s to small for hh:mm).
Sincerely...
AG aka AndyCODE ;-)

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMicrosoft SQL Server > Help: 'Data Overflow' error while exporting [from Ms Access] to Ms SQL 2000


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump




 Free IT White Papers!
 
How to Present Effectively Online
This white paper offers practical and actionable advice on the key steps that any presenter should consider as they plan and execute a Webinar or online meeting.

Request Your Free Technology Downloads!
 
Open Source Security Myths
Open Source Software (OSS) is computer software whose source code is available to the general public with relaxed or non-existent intellectual property restrictions (or arrangement such as the public domain), and is usually developed with the input of many contributors.

Request Your Free Technology Downloads!
 
Power and Cooling Capacity Management for Data Centers
This paper describes the principles for achieving power and cooling capacity management.

Request Your Free Technology Downloads!
 
Scalable, Fault-Tolerant NAS for Oracle - The Next Generation
For several years NAS has been evolving as a storage alternative for Oracle databases, and for good reason: NAS is quite often the simplest, most cost-effective storage approach for Oracle. Learn about the benefits that HP's approach to scalable NAS brings to Oracle environments in this comprehensive white paper.

Request Your Free Technology Downloads!
 
Understanding Web Application Security Challenges
This white paper discusses many common threats and preventive measures for Web application security, and explains what you can do to help protect your organization.

Request Your Free Technology Downloads!
 

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 




© 2003-2009 by Developer Shed. All rights reserved. DS Cluster 2 Hosted by Hostway
For more Enterprise Application Development news, visit eWeek