There is no actual VBS file. I run it like this from VBA: Sub UpdateReadSQLite2(bShowSQL As Boolean)
Dim oShell UpdateReadTextFile bShowSQL, True Application.StatusBar = _ "transferring the data from ReadCodeNoQuotes.txt to the SQLite DB" Set oShell = CreateObject("WSCript.shell") oShell.Run "cmd /C C:\SQLite\ReadCode.bat", 0 Set oShell = Nothing Application.StatusBar = False End Sub Still, these are minor details and I will figure that out. RBS -----Original Message----- From: Kees Nuyt [mailto:[EMAIL PROTECTED] Sent: 15 November 2006 20:30 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Importing text file via .bat file On Wed, 15 Nov 2006 19:46:32 -0000, you wrote: >Kees, > >Just one other thing needed. >In the .sql file is there a way to notify VB that the text import is >finished? I run the .bat file now from VBS, so it won't be visible. >I couldn't see anything suitable in the dot commands to tell VB. > >RBS It is done when the .bat returns to VBS, I guess. You could try to execute like this (just guessing, i never use VBS): start /w ReadCode.bat Or add this to the sql script: **** at the top: if exist signal.txt del signal.txt **** at the bottom: .output signal.txt select SUBJECT_TYPE from ReadCode limit 1; and detect the presence of the file signal.txt in your VBS script. Or do everything in your .bat (or better, .cmd). -- ( Kees Nuyt ) c[_] ---------------------------------------------------------------------------- - To unsubscribe, send email to [EMAIL PROTECTED] ---------------------------------------------------------------------------- - ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------