database creation

[rchris494]

i am very new to access.

i would like to create a database in access when i import from a .CSV file it will only import the data i want. if the data does not have a field created; create one and place the data in that field. so i would need to do a check when importing this data.

currently we hand key all this information in and it is very time consuming.

example .csv

"File Name","","C:\Univ\Reports\1022=231022=FMADACTags-091022_Log_231405.csv"
"Source File","","1022=231022=FMADACTags"
"Run Date","","10/22/2009"
"Run Time","","11:14:05 PM"
"Computer Name","","DCB-LRAR-03"
"User Name","","dc003"
"Splitout Sequence","","000-516-247"
""
"Output File","Customer Label Name","Label Name","Label Count","Page Count"


"1022=231022=FMADAC.FM-Accolade10-ACC.14511_ADACT","ACC","FM-Accolade10-ACC",510,56
"1022=231022=FMADAC.FM-Adtag10-ADT.14512_ADACT","AD10","FM-Adtag10-ADT",28,10

but the next .csv will have the following

"File Name","","C:\Univ\Reports\1022=231022=FMADACTags-091022_Log_231405.csv"
"Source File","","1022=231022=FMADACTags"
"Run Date","","10/22/2009"
"Run Time","","11:14:05 PM"
"Computer Name","","DCB-LRAR-03"
"User Name","","dc003"
"Splitout Sequence","","000-516-247"
""
"Output File","Customer Label Name","Label Name","Label Count","Page Count"
"1022=231022=FMADAC.FM-Accolade10-ACC.14511_ADACT","ACC","FM-Accolade10-ACC",510,56
"1022=231022=FMADAC.FM-Adtag10-ADT.14512_ADACT","AD10","FM-Adtag10-ADT",28,10
"1022=231022=FMADAC.FM-Adtag20-ADD.14513_ADACT","AD20","FM-Adtag20-ADT",28,10

i would like to have 1022=231022=FMADACTags as the first field, 2nd to field lable name (example: ad10) but if there is not this field created create it and place the Page Count under that field. I also want this to always append to an exsisting database until changed

i would like to make this as simple as running a macro or .bat file.

i hope this all makes some sense. if not i can try to explain better.

can someone help me or point me in a direct to help get this started??

[dsmacs]

Hi Chris,

Can you attach a small sample csv file with differt field lengths or email me?

d [dot] mcdonald @ ozemail [dot] com [dot] au

I'll do up a sample for you.

Regards
Darren