Dear List, When I run the following query by pressing a command button in VB.
Sub Update_SystemTab() Dim QueryStatement As String QueryStatement = "INSERT INTO System(System_ID, Oblast_Name, District_Name, Village_Name,Longitude, Latitude, Elevation ) IN 'C:\Irshad_UN\Rehabilitated_Water_Supply.mdb'SELECT System.System_ID, System.Oblast_Name, System.District_Name, System.Village_Name, System.Longitude, System.Latitude, System.Elevation FROM System IN 'C:\Irshad_UN\WSS_Khatlon.mdb';" Docmd.RunSQL (QueryStatement) End Sub I get a runtime error 424, Object required. I am running this from Arcview 9.1 Thanks in advance. Irshad __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/