i am currently working in an access database, yesterday i imported my access to sql. i can not import my data but only my tables because there is a line error at 7751. i do not understand, can anyone help?
SQLServer doesn't have support for queries, forms, modules, reports. Queryes you can save in a text file with extension .sql, you can run them in query analizer. Modules you should translate in SQLServer's programming sql script language as stored procedures or as .sql files. Queries you can put also in views. Reports and windows interfaces from macrosses and modules you should eliminate. Automatically you can import only tables. John Fill
how i import is through the import and export wizards in sql. i am importing one table and it's data. the error i am recieving is Error at Desination for row num 7751. i am completely new at all of this. i am teaching myself sql and need help.
You can't fix it. If you want to inport SQL's, open queryes in access as sql view, copy/paste the code in a text file and save it in as .sql file. The same try to do with modules. The forms and the reports you can't import. The macrosses try to convert to VBA procedure. After it you should do some much work on translating and eliminating preocedures what SQLServer doesn't support. Also you'll not be able to import the relationship and the primarry/foreign keis. John Fill
right now i am just testing with sql. i got rid of the record and everything works fine. it seemed to look like the other records, the same field sizes and everything. so i don't know what the deal was with that record, what i did was just imported the data and created my own table in sql. so far that seems to work fine.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.