I went down this road awhile back and what I discovered was that a flat format in your csv files does not lend well towards importing them into an ever-changing database. What you need is a key which is defined for every attribute, then eventually when you have all your .csv files collected you can dump the contents of them into a single table and run a cross-tab query (in access) to have the columns generated.

I've got the whole thing working, ..my csv's are automatically copied to the local domain server, then a service on the server fires the csv off to the central server over a WAN, then this csv file is gobbled up by the main database. It's actually pretty bitchin once you get it all going. Here's the part that you should pay attention to now before you get too far down the road (if you plan on using the information in a dynamic database down the road).. My export code looks like this:

(note that some of the items default gateway and adapters in my script are calculated by other routines besides @ADDRESS.. because kixtart doesn't know what to do in machines with more than one adapter)

;-----------------------------------------------------------------
; SUBROUTINE: export_data
; Exports all information variables to a comma delimited text file which
; is copied to the domain's management server then processed into a database
;-----------------------------------------------------------------
:export_data

DIM rtn
DIM n
DIM export_file

$export_file = $logfile_directory + "\" + $physical_mac + ".csv"

del "$logfile_directory\*.csv"
;del "$export_file"
$rtn = open(10, "$export_file", 5)
if $rtn = 0
; Newline
$n = chr(13) + chr(10)

$rtn = writeline(10, '"$physical_mac","comp_name","$comp_name"$n')
$rtn = writeline(10, '"$physical_mac","user_id","$user_id"$n')
$rtn = writeline(10, '"$physical_mac","asset_number","$asset_number"$n')
$rtn = writeline(10, '"$physical_mac","os","$os"$n')
$rtn = writeline(10, '"$physical_mac","host_domain","$host_domain"$n')
$rtn = writeline(10, '"$physical_mac","logon_domain","$logon_domain"$n')
$rtn = writeline(10, '"$physical_mac","logon_server","$logon_server"$n')
$rtn = writeline(10, '"$physical_mac","ip_address","$host_ip_addr"$n')
$rtn = writeline(10, '"$physical_mac","def_gateway","$def_gateway"$n')
$rtn = writeline(10, '"$physical_mac","logon_date","$logon_date"$n')
$rtn = writeline(10, '"$physical_mac","logon_time","$logon_time"$n')
$rtn = writeline(10, '"$physical_mac","user_name","$user_name"$n')
$rtn = writeline(10, '"$physical_mac","user_priv","$user_priv"$n')
$rtn = writeline(10, '"$physical_mac","av_inst","$av9x_installed"$n')
$rtn = writeline(10, '"$physical_mac","np_ver","$np_version"$n')
$rtn = writeline(10, '"$physical_mac","av_dom","$av_dom_loc"$n')
$rtn = writeline(10, '"$physical_mac","av_err","$av_dom_err"$n')
$rtn = writeline(10, '"$physical_mac","aw_inst","$aw9x_installed"$n')
$rtn = writeline(10, '"$physical_mac","win_mac","$mac"$n')

$rtn = writeline(10, '"$physical_mac","total_dev","$total_dev"$n')
$rtn = writeline(10, '"$physical_mac","total_ppp","$total_ppp"$n')
$rtn = writeline(10, '"$physical_mac","total_aol","$total_aol"$n')

$rtn = writeline(10, '"$physical_mac","msnet_ver","$msnet_ver"$n')
$rtn = writeline(10, '"$physical_mac","kix_ver","$kix_ver"$n')
$rtn = writeline(10, '"$physical_mac","net_ver","$net_ver"$n')
$rtn = writeline(10, '"$physical_mac","windir","$windir"$n')

$rtn = writeline(10, '"$physical_mac","vs_ver","$vs_ver"$n')
$rtn = writeline(10, '"$physical_mac","sdat_ver","$sdat_ver"$n')

$rtn = writeline(10, '"$physical_mac","user_profiles","$user_profiles"$n')
$rtn = writeline(10, '"$physical_mac","loans_mode","$loans_mode"$n')

$rtn = close(10)

; copy the infofile to the tagfiles share
? "[Copying data export: $export_file to \\$inventory_server\$tagfile_share]" ?
copy "$export_file" "\\$inventory_server\$tagfile_share" /h
If @ERROR <> 0
"Error: while copying file" $export_file ?
"@SERROR" ?
Endif
Else
? "Export_file could not be written: " $export_file ?
"Please contact the MIS" ?
"Error: @SERROR" ?
Exit
Endif
Return

------------------
K Torkelson
Sys Admin Analyst
ktorkelson@providentfunding.com