Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Import foxpro table into sql server 2000 problem with datefield

Status
Not open for further replies.
WimTIEN

WimTIEN

IS-IT--Management
Feb 8, 2005
2
NL
When i am importing a foxpro table, linked by ODBC, i have a problem with date field.

The definition in foxpro is standard date.

While importing the record is refused with the error "insert error, column nn ('fieldname', DBTYPE-DBTIMESTAMP), status 6: Data overflow.

So, i have to import foxpro tables while using the ODBS foxpro driver. I want to do that with a DTS. On with way i can import a date file without an error!

Thanks you when you responding my question
 
Status
Not open for further replies.

Similar threads

V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
373
Volvere
V
gbaughma
  • Locked
  • Question
SQL Performance
Replies
11
Views
346
pjw001
pjw001
peac3
  • Locked
  • Question
Consolidate multiple rows into single row 1
Replies
4
Views
339
Chris Miller
Chris Miller
eboughey1008
  • Locked
  • Question
Import columns from one table into another table with dissimilar field layout
Replies
7
Views
167
Chris Miller
Chris Miller
peac3
  • Locked
  • Question
split one row into multiple rows... help pls 2
Replies
12
Views
517
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top