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 |
|
aarumugavel
Starting Member
8 Posts |
 Posted - 2007-10-15 : 00:53:01
|
| hi, i export datas from sql server 2000 to Ms Access. but few tables only not expot. and error has come "the microsoft jet data base engine cannot find the input or Query "<t.n>" make sure it exists and that its name is spelled correctly.but tables are live in sql server 2000.Please give solution as soon |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2007-10-15 : 04:08:21
|
| Was there a specific error number? Have you got [square barckets] around all the various elements?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
 |
|
|
aarumugavel
Starting Member
8 Posts |
Posted - 2007-10-15 : 04:57:06
|
Thanks for reply.No Error Number is display. this error occure by the using of export and import option in sql server 2000 (DTS Package).i export all tables into MS Accesss file but some tables only not exported and error is came. but i export the some specific tables only then it exported successfully.Is any specific size limit in MS Access? becuase the all tables having more than 4 yrs records.![]() |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2007-10-16 : 11:10:10
|
| 4yrs records in iteself may not be an issue , it's the AMOUNT which is more relevant. Have you tried putting [] around table name , just in case one of your table names is a reserved word?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
|
|
|
err - export from sql server 2000 and MsAccess