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!

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

Importing data SQL Server

Status
Not open for further replies.

ijitnoin

Programmer
Jan 26, 2006
18
US
Hello,

Is it possible to import data (dbase or text type)from Access front end into tables linked to the MS SQL Server? When tables were linked to a Access backend, this work properly with no error messages. Basicly data is being input to the temporary table correctly, but one error I'm receiving is 'unable to delete'. Once record are put in the permanent tables, data is removed from the temporary tables for the next run/import of outside data. Your help/advise/answer will be appreciated.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top