i have yet another question for the experts, i need to be able to import a list of dates and ID numbers from a text file i suspect i need to format my text file as such
StaffID,Date1,Date2,Date3,Date4 etc
eg data
Expand|Select|Wrap|Line Numbers
- 1,21/10/2009,22/10/2009,23/10/2009
- 2,01/05/2009
- 3,09/08/2009,10/08/2009
StaffID,Date1
eg
Expand|Select|Wrap|Line Numbers
- 1,21/10/2009
- 1,22/10/2009
- 1,23/10/2009
- 2,01/05/2009
- 3,09/08/2009
- 3,10/08/2009
1) Which is this the best way to format this data?
2) how would i extract the variable number of dates (not constant per StaffID) for 1st eg and keep it in vb because i will need to some additional data before inserting into table
3) how would i open a prompt to locate the txt fileand then continue the code, can this be done? (not essential)
any help would be much appreciated
Thanks again, Dan