S
sparky
I have a two part question. Access 97.
I want to know first if I can append from a Excel file that is a .csv, or do
I have to convert it first to a .xls?
I know how to append from a .xls file.
The .csv file (before conversion to .xls) is downloaded from another
machine. each time the the file is downloaded (every month), it contain the
total data, which will consist of hourly readings. Each download has the
previous month's data, with the present month's data added to end of file.
There is no set limit to number of months, that is, at present, my download
for December 07 contains october and Novermber's data as well as December's,
whereas my November's download had just oct. & Nov's data. I can manually
delete the unecessary data, keeping the current month'd data only. This
takes a little bit of work, and I want to get this setup so this work is not
necessary.
My thought was to take the .csv file, append it straight-away (or after
converting it to .xls) to my table in Access. The Append query needs to be
setup to ignore duplicate info, which will allow only current data to be
appended. I'm just not sure how to do this.
My table has an autonumber id field, time field, date field, and various
"other" fields. I won't be able to use the time field, as each day of each
month will have the same time of readings. The date field is where I think
my criteria needs to be enetered, but I don't know what expression I need to
use to keep the duplicate info from being appended to my table.
Or would it be better to allow the duplicates to be appended along with the
new data, then just run a delete duplicate query? Any help on the setup of
this type would be appreciated.
Rick
I want to know first if I can append from a Excel file that is a .csv, or do
I have to convert it first to a .xls?
I know how to append from a .xls file.
The .csv file (before conversion to .xls) is downloaded from another
machine. each time the the file is downloaded (every month), it contain the
total data, which will consist of hourly readings. Each download has the
previous month's data, with the present month's data added to end of file.
There is no set limit to number of months, that is, at present, my download
for December 07 contains october and Novermber's data as well as December's,
whereas my November's download had just oct. & Nov's data. I can manually
delete the unecessary data, keeping the current month'd data only. This
takes a little bit of work, and I want to get this setup so this work is not
necessary.
My thought was to take the .csv file, append it straight-away (or after
converting it to .xls) to my table in Access. The Append query needs to be
setup to ignore duplicate info, which will allow only current data to be
appended. I'm just not sure how to do this.
My table has an autonumber id field, time field, date field, and various
"other" fields. I won't be able to use the time field, as each day of each
month will have the same time of readings. The date field is where I think
my criteria needs to be enetered, but I don't know what expression I need to
use to keep the duplicate info from being appended to my table.
Or would it be better to allow the duplicates to be appended along with the
new data, then just run a delete duplicate query? Any help on the setup of
this type would be appreciated.
Rick