Click here to Skip to main content
16,007,760 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: DLL Pin
Mycroft Holmes20-Aug-08 19:10
professionalMycroft Holmes20-Aug-08 19:10 
GeneralRe: DLL Pin
Paul Conrad21-Aug-08 18:44
professionalPaul Conrad21-Aug-08 18:44 
AnswerRe: DLL Pin
Christian Graus20-Aug-08 19:29
protectorChristian Graus20-Aug-08 19:29 
GeneralRe: DLL Pin
Paul Conrad21-Aug-08 18:45
professionalPaul Conrad21-Aug-08 18:45 
QuestionGetting list of Visited Sites by Vb.net Pin
Anubhava Dimri20-Aug-08 18:51
Anubhava Dimri20-Aug-08 18:51 
AnswerRe: Getting list of Visited Sites by Vb.net Pin
Christian Graus20-Aug-08 19:30
protectorChristian Graus20-Aug-08 19:30 
QuestionImport CSV file to MS Access Pin
scothykonma20-Aug-08 18:19
scothykonma20-Aug-08 18:19 
AnswerRe: Import CSV file to MS Access Pin
emimmortal20-Aug-08 18:53
emimmortal20-Aug-08 18:53 
You can open the mdb with any .net connection and use the INSERT SQL to import the csv data.
Ensure the target table is blank and make a Schema.ini file for define the schema of the csv file.

eg.
string sql = string.Format("insert into {0} select * from [Text;FMT=Delimited(|);HDR=No;DATABASE={1};].[{2}#csv];",
info.TableName, info.FilePath, info.FileName);

System.Data.Odbc.OdbcCommand command = new System.Data.Odbc.OdbcCommand(sql, connection);
command.ExecuteNonQuery();

for schema.ini
http://msdn.microsoft.com/en-us/library/ms709353.aspx
Smile | :)

Emimmortal

GeneralRe: Import CSV file to MS Access Pin
scothykonma20-Aug-08 22:57
scothykonma20-Aug-08 22:57 
AnswerRe: Import CSV file to MS Access Pin
Mycroft Holmes20-Aug-08 19:13
professionalMycroft Holmes20-Aug-08 19:13 
QuestionUnedited Articles Pin
Taylor Kobani20-Aug-08 8:35
Taylor Kobani20-Aug-08 8:35 
AnswerRe: Unedited Articles Pin
jzonthemtn20-Aug-08 9:29
jzonthemtn20-Aug-08 9:29 
AnswerRe: Unedited Articles Pin
Christian Graus20-Aug-08 15:12
protectorChristian Graus20-Aug-08 15:12 
QuestionA couple Datagridview column header formatting questions [modified] Pin
Jon_Boy20-Aug-08 8:20
Jon_Boy20-Aug-08 8:20 
QuestionWait in Background Worker Pin
captainmogo20-Aug-08 7:23
captainmogo20-Aug-08 7:23 
AnswerRe: Wait in Background Worker Pin
Gideon Engelberth20-Aug-08 7:44
Gideon Engelberth20-Aug-08 7:44 
QuestionConnect to a password protected Access database!! Pin
John Kh20-Aug-08 7:09
John Kh20-Aug-08 7:09 
AnswerRe: Connect to a password protected Access database!! Pin
Kschuler20-Aug-08 10:25
Kschuler20-Aug-08 10:25 
AnswerRe: Connect to a password protected Access database!! Pin
emimmortal20-Aug-08 19:01
emimmortal20-Aug-08 19:01 
GeneralRe: Connect to a password protected Access database!! Pin
John Kh22-Aug-08 22:56
John Kh22-Aug-08 22:56 
QuestionVB:net mysql subtract value Pin
Pestinha198420-Aug-08 6:06
Pestinha198420-Aug-08 6:06 
AnswerRe: VB:net mysql subtract value Pin
Gideon Engelberth20-Aug-08 7:45
Gideon Engelberth20-Aug-08 7:45 
GeneralRe: VB:net mysql subtract value Pin
Pestinha198420-Aug-08 7:53
Pestinha198420-Aug-08 7:53 
QuestionHow can i count bytes in an array of bytes ? Pin
Kobi_Z20-Aug-08 5:00
Kobi_Z20-Aug-08 5:00 
GeneralRe: How can i count bytes in an array of bytes ? Pin
Kschuler20-Aug-08 10:27
Kschuler20-Aug-08 10:27 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.