J
JacquelineAB
I have an EXCEL spreadsheet with 700 lines of data and 200 columns. It was
set up with COLUMN A as the data header with the individual columns being the
data fields. ACCESS will not import this correctly since it requires the
first ROW to the the header as opposed to the first COLUMN. Is there a way
to switch this in ACCESS? The number of rows will NOT transpose in EXCEL as
they exceed the column limits. Can this be done in ACCESS or I am in deep
trouble getting this info into a new database format? I am guessing I need to
use the Pivot Table/Chart function but i am not finding failproof
instructions on how to do this. CAN ANYONE PLEASE HELP??
set up with COLUMN A as the data header with the individual columns being the
data fields. ACCESS will not import this correctly since it requires the
first ROW to the the header as opposed to the first COLUMN. Is there a way
to switch this in ACCESS? The number of rows will NOT transpose in EXCEL as
they exceed the column limits. Can this be done in ACCESS or I am in deep
trouble getting this info into a new database format? I am guessing I need to
use the Pivot Table/Chart function but i am not finding failproof
instructions on how to do this. CAN ANYONE PLEASE HELP??