Transfer Files

[emily23]

Hi everyone! I primarily work with embedded visual basic, but I currently have to tranfer files into a database using VB 6. Does snyone have the statement I would use to pull fields from a particular file and send them into a predesigned database? Thanks in advance!
Emily

 

[jerasi]

That depends on the format of the file (is it tab delimited? is every record on only one line?) if this is the case you should try using the FileSystemObject to open the file and read line by line (loop) and use the "Split" function to put the fields in an array (Split(line_text, delimiter)) from here you can construct your SQL statment and execute it.

Hope this helps.