Article: Uploading MDB to SQL Server Programmatically

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.

All Forums

Site Related Forums

Article Discussion

Article: Uploading MDB to SQL Server Programmatically

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-08-07 : 02:14:32

Yashwant writes "Can I upload my local mdb files on the SQL server(and other way round) on the Web Programmatically without using SQL server Desktop for DTC/Import or export utility. I am using VB as my local front end and ASP as my front end for web. Please Help --ASAP"

Article Link.

kflim
Starting Member

1 Post

Posted - 2003-09-10 : 04:03:23

I tried used
cnAExecute "INSERT INTO UserInfo SELET * FROM UserInfo IN " & """" & sLocation & """"

in visualbasic but an error occur said incorrect syntax near the keyword 'IN'.
sLocation = "c:\user.mdb"

:)

youssef
Starting Member

1 Post

Posted - 2004-07-13 : 11:37:27

Hi,

I have the same problem that you.

I using a sql database that I created the same structure of the table in my ACCESS Table.
I using linked server.
At this point, all are ok.
In my SQL databse, I create a view of my linked table of ACCESS.
At this moment , I can see all records from my ACCESS DB.
But now, I would like to use a TRIGGER in my VIEW for retrieve if a new record was inserted in my ACCESS TABLE and inserte it in my SQL table.
I create a Trigger in my View :

the code is :

CREATE TRIGGER TG_INSERT_LogStatus0 ON [dbo].[VIEW_MTX_BTS_LOG]
---------------------------------------------------------- INSERT in Log
--FOR INSERT
INSTEAD OF INSERT
AS
BEGIN
declare
@Log_Date datetime,
@Log_Input smallint,
@Log_Level smallint,
@Log_Milliseconds smallint,
@Log_Output smallint,
@Log_Panel smallint,
@Log_Response smallint,
@Log_Status smallint

set @Log_Date =GETDATE()
set @Log_Input =1
set @Log_Level =1
set @Log_Milliseconds =1
set @Log_Output =1
set @Log_Panel =1
set @Log_Response =1
set @Log_Status =1

exec InsertLog @Log_Date,@Log_Input,@Log_Level,@Log_Milliseconds,@Log_Output,@Log_Panel,@Log_Response,@Log_Status

ENDBut nothing when a new record was inserted in my ACCESS TABLE.

Can you resolve my problem ?

Best regards

anar
Starting Member

1 Post

Posted - 2006-12-08 : 03:34:59

worked nice, thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources