How do you write variable length comma delimited files using access. For example,
LI,RB2861,124,CA,0
LI,RB2746,440,CA,0
AI,409999,609932, 385005,100,Favorite Market,2222 Main Street,,Santa Monica,CA,90404,1, 1,0,11242003
IH,409999,609932,,,11242003,10001,11242003
II,RB1718,1,2,CA,3200,,0
II,RB2746,2,1,CA,3200,,0
How do you define the file? Do you put the entire line together using concatentation? Do you hard code the <CR>?
LI,RB2861,124,CA,0
LI,RB2746,440,CA,0
AI,409999,609932, 385005,100,Favorite Market,2222 Main Street,,Santa Monica,CA,90404,1, 1,0,11242003
IH,409999,609932,,,11242003,10001,11242003
II,RB1718,1,2,CA,3200,,0
II,RB2746,2,1,CA,3200,,0
How do you define the file? Do you put the entire line together using concatentation? Do you hard code the <CR>?