tonytone
New member
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.
Use Access import specs into vb.net
- Thread starter tonytone
- Start date
Robby
Moderator
You can use the Insert Into (sql) statement of the ExecuteNonQuery method of the OleDBCommand.
Robby
Moderator
You can use this function to do it, just change all the SQL for OleDB ...
http://www.computerhelp.forum/showthread.php?s=&threadid=70299&highlight=ExecuteNonQuery
http://www.computerhelp.forum/showthread.php?s=&threadid=70299&highlight=ExecuteNonQuery
Robby
Moderator
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.
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.
tonytone
New member
Thank you for the help. I will try both scenarios.