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 |
|
mharvey
Starting Member
13 Posts |
 Posted - 2003-02-20 : 15:03:27
|
| Hello:I'm relatively new to SQLServer; I'm trying to get data from Access2000 tables into SQLServer tables; I have two questions.1) When I try to use DTS to import Access data to SQL server I get an error message regarding data overflow on a date/time column but, this column contains a NULL value. This does not make sense to me. Any suggestions?2) After setting up a Linked Server to access tables in an ACCESS2000 database, and trying to view the tables within, I receive error message 7399 (Jet 4.0 reported an error). I looked at examples in the SQL Server Online books and the help text from within Enterprise Manager and the Linked Server definition seems to be correct. The Access2000 Db does NOT have the security feature installed so, everyone logs on as "Admin". Any clues, SQL Gurus?Any insights would be greatly appreciated.Thank You,Michael |
|
|
|
|
|
DTS/Linked Servers