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.
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.