tonytone Posted April 3, 2003 Posted April 3, 2003 Is there any way someone could use the Access import specs for vb.net. Or is there something I could use to import a comma delimited file into accessxp while using vb.net? Thanks. Quote
Moderators Robby Posted April 3, 2003 Moderators Posted April 3, 2003 You can use the Insert Into (sql) statement of the ExecuteNonQuery method of the OleDBCommand. Quote Visit...Bassic Software
Moderators Robby Posted April 3, 2003 Moderators Posted April 3, 2003 You can use this function to do it, just change all the SQL for OleDB ... http://www.xtremedotnettalk.com/showthread.php?s=&threadid=70299&highlight=ExecuteNonQuery Quote Visit...Bassic Software
Moderators Robby Posted April 3, 2003 Moderators Posted April 3, 2003 sorry, I forgot the Insert statement... In case you want to write to a table outside the current DB.... "INSERT INTO Table1( Field1,Field2,Field3,Field4) _ IN 'D:/Path/Datbase.mdb' _ SELECT Field1,Field2,Field3,Field4 _ FROM Table2" Both parts of this string must have the same number of fields and data types. Quote Visit...Bassic Software
tonytone Posted April 5, 2003 Author Posted April 5, 2003 Thank you for the help. I will try both scenarios. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.