KiXforms Forum Index KiXforms
The Forum for the KiXforms Community
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 Quick Links 
Site News
Downloads
Documentation
Donations
Script Archive
Tracking Systems

Access DB Code prob. Select into

 
Post new topic   Reply to topic    KiXforms Forum Index -> Discussion
View previous topic :: View next topic  
Author Message
Radimus
KiXforms Enthusiast
KiXforms Enthusiast


Joined: 05 Mar 2003
Posts: 157
Location: Tampa, Florida

PostPosted: Wed Nov 29, 2006 6:31 pm    Post subject: Access DB Code prob. Select into Reply with quote

I'm trying to copy an entire table from db1 into identical table in db2

Code:

break on
$nul = SetOption( "WrapAtEOL", "ON" )


$srcDB = '"@scriptdir\ASPENLocalOld.mdb"'
$dstDB = '"@scriptdir\ASPENLocalNew.mdb"'



$Conn = CreateObject("ADODB.Connection")
$DSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=$srcDB"
$Conn.Open($DSN)
? @serror

if not @error   
   $SQL = 'INSERT INTO [MS Access;DATABASE=$dstDB].["ASPEN Databases"] SELECT * FROM "ASPEN Databases"'
? $sql
   $Conn.Execute($SQL)
? @serror
   $Conn.Close
Endif
$Connection = 0

result is:
Quote:
The operation completed successfully.
INSERT INTO [MS Access;DATABASE="C:\Documents and Settings\wheelerc\Desktop\ASPENLocalNew.mdb"].["ASPEN Databases"] SELECT * FROM "ASPEN Databases"
COM exception error "Execute" (Microsoft JET Database Engine - Syntax error in query. Incomplete query clause.) [-2147352567/80020009]


help please...
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
Radimus
KiXforms Enthusiast
KiXforms Enthusiast


Joined: 05 Mar 2003
Posts: 157
Location: Tampa, Florida

PostPosted: Wed Nov 29, 2006 6:45 pm    Post subject: Reply with quote

also tried:
$SQL = 'INSERT INTO [$dstDB].[ASPEN Databases] SELECT * FROM [ASPEN Databases]'
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
benny69
KiXforms Advocate
KiXforms Advocate


Joined: 30 Oct 2003
Posts: 567
Location: Lincoln, Ne

PostPosted: Wed Nov 29, 2006 7:34 pm    Post subject: Reply with quote

Hi Radimus,
This board is dedicated to KiXforms, your question is best asked over at KiXtart.org.

_________________
Wait don't order yet,... get KiXforms Designer .NET 2.0 (Beta)
KiXforms Designer .NET 2.0 (Beta)
Back to top
View user's profile Send private message Send e-mail
Les
KiXforms Aficionado
KiXforms Aficionado


Joined: 24 Dec 2003
Posts: 317

PostPosted: Wed Nov 29, 2006 8:29 pm    Post subject: Reply with quote

Eh Rad, forget your korg password?
_________________
The Repro Man
Stealing for a living!
Back to top
View user's profile Send private message
Radimus
KiXforms Enthusiast
KiXforms Enthusiast


Joined: 05 Mar 2003
Posts: 157
Location: Tampa, Florida

PostPosted: Wed Nov 29, 2006 8:45 pm    Post subject: Reply with quote

it is still down isn't it...

and they reset the PW, and it will not accept the one he provided
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
benny69
KiXforms Advocate
KiXforms Advocate


Joined: 30 Oct 2003
Posts: 567
Location: Lincoln, Ne

PostPosted: Wed Nov 29, 2006 8:49 pm    Post subject: Reply with quote

I will try to catch doc online and let him know you need help with your password. does he have an email address he can send the info to?
_________________
Wait don't order yet,... get KiXforms Designer .NET 2.0 (Beta)
KiXforms Designer .NET 2.0 (Beta)
Back to top
View user's profile Send private message Send e-mail
benny69
KiXforms Advocate
KiXforms Advocate


Joined: 30 Oct 2003
Posts: 567
Location: Lincoln, Ne

PostPosted: Wed Nov 29, 2006 8:59 pm    Post subject: Reply with quote

Doc says he does not have an email for you, and he asks you to come online (MSN) and ding him, so he can help you out.
_________________
Wait don't order yet,... get KiXforms Designer .NET 2.0 (Beta)
KiXforms Designer .NET 2.0 (Beta)
Back to top
View user's profile Send private message Send e-mail
ntdoc
KiXforms Supporter
KiXforms Supporter


Joined: 05 Mar 2003
Posts: 77
Location: Mouse Country

PostPosted: Wed Nov 29, 2006 9:56 pm    Post subject: Reply with quote

I sent e-mail again with temp password to radimus at wheelerfam dot com

If not correct then I need a new e-mail addy.
 
Back to top
View user's profile Send private message Visit poster's website AIM Address MSN Messenger
Les
KiXforms Aficionado
KiXforms Aficionado


Joined: 24 Dec 2003
Posts: 317

PostPosted: Wed Nov 29, 2006 11:41 pm    Post subject: Reply with quote

DOC, you should not post an addy in clear text for the bots.
_________________
The Repro Man
Stealing for a living!
Back to top
View user's profile Send private message
Rod
KiXforms Webmaster
KiXforms Webmaster


Joined: 22 Feb 2003
Posts: 202
Location: United Kingdom

PostPosted: Thu Nov 30, 2006 8:34 am    Post subject: Reply with quote

I edited Ron's post to save the e-mail addy from bots, and moved this topic to the Discussion forum as it really doesn't belong anywhere else.

Rod.

_________________
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    KiXforms Forum Index -> Discussion All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum


Powered by phpBB © 2001, 2005 phpBB Group