Frank Schönheit - Sun Microsystems Germany wrote:
Hi Barbara,
Your idea sounds somewhat unusual for a database (in which situations,
for instance, would you want to copy a rectangular portion to a location
starting at another column? How often, really, does one have data where
this makes sense?). Or is this just me?
For what it's worth
Just spent a little time with MSO 2007 and StarOffice 8 - copying,
pasting, dragging and dropping
Copy / paste of a range of cells within a table in Access - yup you can
do that. Why? Darned if I know, but someone must of wanted it.
Copy / paste ( drag / drop ) a range of cells from Excel into a range in
an Access table - Yes.
You must select a target range of cells
If you select existing records as the target range the records are
updated with the data from the source.
If your source was 5 rows long but your target is 2 rows the first 2
rows of data are written into the current selected record / columns.
If your source is 5 rows, you highlight the last 2 rows with date and
the insert row, all 5 rows are written - 2 records updated, 3 inserted.
If you highlight just a single cell in an Access dataview and drop a
range of cells, you paste only the first cells value.
If you enter edit mode in a cell, and paste a range of cells the
behavior depends on the data type of receiving cell
- if it is text the data is written as a tab/LF separated string.
- if it is a numeric you get only the value of the first cell from
your source
For all these actions Access first writes the data - displays it on
screen ( as best it can ) and then asks for confirmation to post the data.
If your drag / drop a range of cells from Excel to Access and drop on
the Table section ( not in a data grid ) an import is triggered.
- You are asked if the first row contains column names ( Yes / No )
- The data is imported without further interrogation
- If a column has mixed data types it is created as TEXT
The new table name is the same as the Excel file the data was imported from.
If you drop data from the same excel file into a second table it is
named the same but with an incrementing post-fix number.
Error handling - Access has done it this way for ever IIRCC - any
records that could not be imported are written to a table named
Copy Errors - IF there is not already a Copy Errors table in the
database. In other words you have to clean up the errant records and
delete this holding table BEFORE your try to import your next set of
records.
If there is already a Copy Errors table - then the data that could not
be copied is - well - not copied.
You can copy / paste data from Calc to Access only by pasting the data
into a selected range of cells in an access table data view.
You can NOT trigger a table import in Access with data from Calc via the
clipboard or drag and drop.
You can copy / paste a range of cells from an Access dataview to an
Excel spreadsheet.
You can not paste into a Calc spreadsheet. ( yes I tried that number of
times - must be a bug in SO8 )
You can drop it onto a Base file and trigger the copy table wizard. (
The pasted data includes the column names form the Access table, even
though only a sub set of the records are copied )
You can not drag a table object from Access to Calc
You can drag a table object from Access to Base - copy table wizard starts.
You can not drag and drop a Table object from Base to Excel, or Access.
--------------------------------------------
I closed up SO8 and started up OOo2.3m_1 to check that copy paste to
Calc again
I can copy a range of cells in an Access dataview and paste them into a
Calc sheet.
I can not drag and drop a table object from Acess to a Calc sheet. -
nothing is inserted.
Just the opposite of what I had with SO8.
Oh and when I tried a Paste Special with a copied range from an Access
dataview into the table section in a Base file - OOo crashed. I'll wait
and try that again in the morning.
Enough for now
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
