Printable View
Hi there,
can I ask for help with my first attempt at VB programming.
I have been asked by my employers to write what they say is a SIMPLE program to loop through a number of text files on a CD, extract some (not all) information from each (posibly by line number) and send it to certain fields in an SQLdatabase. It doesn't sound simple to me, I don't know where to start. As you can imagine, any help would really be appreciated.
Thanks
Hi,
I'd really like to help you, but information is a little scantily!
A few hints:
- For browsing a directory, take a look at the DIR command
- For text file handling look at FREEFILE, OPEN FILE, LINE INPUT etc.
- For database access look at ADO
Hope that helps, just don't panic!
Roger
True, we can try to point you in the right direction.
Look up the following functions/controls in VB help
DIR (to get file names)
CommonDialog (to create an "Open" dialog box, not sure if you need this)
Open (to open the file)
input (to read the file to memory
Arrays (to hold the file details)
Instr() (to search the files for ... whatever)
Split() (to break a file into lines (you may not need this)
RDO / DAO / ADO (your choice od database methods)
SQL language syntax (select, update, insert, delete) for reading and writing to the DB
They dumped you in the deep end, but if they've giving you some time (a month or two) and you keep posting here when you get stuck, then you'll finish fine and learn heaps at the same time, it's not really that hard