Imports from a CSV file to a database.
[Visual Basic]
Public Function ImportFromCsv( _
ByVal csvFileName As String, _
ByVal dbFileName As String, _
ByVal targetTableName As String _
) As Boolean
[C#]
public bool ImportFromCsv(
string csvFileName,
string dbFileName,
string targetTableName
);
Parameters
-
csvFileName
- CSV filename.
-
dbFileName
- Database filename.
-
targetTableName
- Table name.
Return Value
Returns true if successful; otherwise false.
Example
How to import the data of CSV file C:\Data.csv, to the table xxxtbl of the database file C:\Data.mdb.
dao.ImportFromCsv("C:\Data.csv", "C:\Data.mdb", "xxxtbl")
dao.ImportFromCsv("C:\\Data.csv", "C:\\Data.mdb", "xxxtbl");
See Also
AwDao Class | Asterworld.Data Namespace