T
Travis
Importing data into Access isn't much of a problem, I've already
figured out Transfertext.
The data I previously imported was easy to use because the information
in the import table had the same primary key as the records I was
wanting to update.
e.g. when importing stock prices, if you use stock tickers as the
primary key (which is perfectly appropriate to do since stocks have
unique tickers), matching the imported data against the existing data
for the update record is simple.
But now I want to set up some imports which have different keys. I
want to import transaction data from various fund managers. The
primary key in the data I am importing is the account number given to
each client by a fund manager. Because it is possible that the same
account number could be used by different fund managers for different
clients, I can't use the fund manager's account number as a primary
key.
Instead, I use an autonumber primary key for my own records and in the
same table I have fields which include the fund manager and the account
number given by the fund manager.
I can, at the time of import, tell my application which fund manager it
is importing (in fact I have to, since the various data files
distributed by fund managers are all in different formats), so its a
matter of matching the fund manager's account number against my account
number so I can do the update or append.
But I've got no idea how to do it!
Any suggestions?
Travis
figured out Transfertext.
The data I previously imported was easy to use because the information
in the import table had the same primary key as the records I was
wanting to update.
e.g. when importing stock prices, if you use stock tickers as the
primary key (which is perfectly appropriate to do since stocks have
unique tickers), matching the imported data against the existing data
for the update record is simple.
But now I want to set up some imports which have different keys. I
want to import transaction data from various fund managers. The
primary key in the data I am importing is the account number given to
each client by a fund manager. Because it is possible that the same
account number could be used by different fund managers for different
clients, I can't use the fund manager's account number as a primary
key.
Instead, I use an autonumber primary key for my own records and in the
same table I have fields which include the fund manager and the account
number given by the fund manager.
I can, at the time of import, tell my application which fund manager it
is importing (in fact I have to, since the various data files
distributed by fund managers are all in different formats), so its a
matter of matching the fund manager's account number against my account
number so I can do the update or append.
But I've got no idea how to do it!
Any suggestions?
Travis