K
KWhamill
Some times the things that look good in excel don't translate well into
Access. or more importantly, I need to turn financial, information on a
spread sheet into a text file to give to an uploading utility for a database.
the cunudrum i am facing is the layout on the spreadsheet looks something
like this:
stat value trans# Account from AMT Account to Amt
Income amt
alpha# abc 12345 account#1 $$ account#2 $$
account#3 $$
the format for the Uploading utilty needs to look like this (see below) in
*.csv:
stat value trans# Account AMT
alpha# abc 12345 account#1 $$
alpha# abc 12345 account#2 $$
alpha# abc 12345 account#3 $$
Changing the Spreadsheet is a none starter that was actually my first
thought. is there a way to do this in a query or two. I'm going to have to
put it in a macro and run it 5 times. macro within a macro, there is a reason
for this.
thank you for your help.
Access. or more importantly, I need to turn financial, information on a
spread sheet into a text file to give to an uploading utility for a database.
the cunudrum i am facing is the layout on the spreadsheet looks something
like this:
stat value trans# Account from AMT Account to Amt
Income amt
alpha# abc 12345 account#1 $$ account#2 $$
account#3 $$
the format for the Uploading utilty needs to look like this (see below) in
*.csv:
stat value trans# Account AMT
alpha# abc 12345 account#1 $$
alpha# abc 12345 account#2 $$
alpha# abc 12345 account#3 $$
Changing the Spreadsheet is a none starter that was actually my first
thought. is there a way to do this in a query or two. I'm going to have to
put it in a macro and run it 5 times. macro within a macro, there is a reason
for this.
thank you for your help.