Re: Is Access bogus, or is it me?

The other approach that occurred to me was to use some Excel functions
to clean it up before importing to Access. Investigate Excel functions
like TRANSPOSE that might do the trick (Disclaimer: I'm not an Excel
expert).

I need to add my to cents into the rants listed above on this topic.

Here is a valid reason for placing data in column format instead of the
normal row format:

Excel currently has a limitation of 256 columns, I currently have a
project that is required to track upto 650 data elements per unit, with
~300 units worth of data. I need to place this data into Access but
cannot perform a normal "Import from Excel" because all of my data
field names are listed in column 1, instead of row 1.

ie,
__________________________________________________________
Col1 | Col2 | Col3 | Col4 ... One Col for each Unit
SN | X | Y | Z
HiLim1| 10 | 10 | 10
LoLim1| 0 | 0 | 0
T1_250| 2 | 5 | 7
T1_300| 12 | 1 | 5
..
..
..
one row for each test element (650 rows needed)
__________________________________________________________

I cannot perform a transpose of my data as it will break the 256 column
limit.

It sure would be nice for Access to have the capability to import with
column 1 as header instead of the current capability of only row 1 as
header.

How can I do this using Access. I am a whiz in excel macro writing, but
only now starting to use Access.

.

Relevant Pages

  • Re: Oh, where to start??? Reformatting HELP
    ... I did use the TRANSPOSE option. ... Transpose data in Excel. ... Use RegExp search/replace function to trim excess white space. ... Cells b2, b3, b4, etc are the policy numbers for the jobs in column a ...
    (microsoft.public.excel.misc)
  • Re: 200 COL Excel file with 700 rows -how to switch COLS & ROWS in ACC
    ... set up with COLUMN A as the data header with the individual columns being ... first ROW to the the header as opposed to the first COLUMN. ... The number of rows will NOT transpose in EXCEL ...
    (microsoft.public.access.externaldata)
  • Re: put row/column transpose in obvious place, like DATA -Transpose (.
    ... if this is a feature request post it directly to Microsoft: ... > Excel does have the capacity to transpose data in rows to data in ... > "transpose" function. ... > Then Excel explained how to do it. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: The object invoked has disconnected from its clients
    ... Rick (MVP - Excel) ... I've replaced the transpose function now with a loop, and there is still a problem. ... Sheets.Cells.Value = vArr ...
    (microsoft.public.excel.programming)
  • Re: Table Orientation in Word
    ... to put a portrait header/footer on a landscape page. ... > Is there an automatic function to transpose within Word? ... > it in Excel.) ... >> put the header into a text on that page. ...
    (microsoft.public.word.docmanagement)