If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access cells
How do you avoid manually typing data in cells? I would like to cut and paste
series data like in Excel. |
#2
|
|||
|
|||
Access cells
"gorilla" wrote in message
... How do you avoid manually typing data in cells? I would like to cut and paste series data like in Excel. Use an append query. If it's something like an Excel list in a column, create it in Excel, link the spreadsheet as a table, then run an append query. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com |
#3
|
|||
|
|||
Access cells
.... a niggling little detail ...
Access doesn't have "cells". Access isn't a spreadsheet. If you are attempting to 'cut/paste series data', you may be trying to work directly in an Access table. Bad idea, and it reinforces the (mistaken) impression that Access is just a spreadsheet-on-steroids. Try Arvin's suggestion and look into using an append query. Regards Jeff Boyce Microsoft Office/Access MVP "gorilla" wrote in message ... How do you avoid manually typing data in cells? I would like to cut and paste series data like in Excel. |
#4
|
|||
|
|||
Access cells
Hi,
If you are looking to add new rows, you can use the Paste Append option with either a table or a query. It will place the data starting in the first column, up through the number of columns that you have copied, if there are enough columns. So you should make sure that your columns match. Otherwise, you can highlight some rows that you want to replace. Or some columns. With columns it will start the replace at the top of the table. I would suggest you try it out on a copy of the table first. Or in a testing copy of the database. That way, if you mess up, you have not messed up the real data. Clifford Bass "gorilla" wrote: How do you avoid manually typing data in cells? I would like to cut and paste series data like in Excel. |
#5
|
|||
|
|||
Access cells
I plan to try these suggestions. I need to learn more about queries, I was
thinking that you had a table in Access, and had maybe a relationship with another table to then start running queries. Right now, I just opened up the program and it was just a grey screen. I wanted to paste some Excel data, and try to build a database. I was thinking Access was similar to Excel. Just a spreadsheet on Steriods as Jeff said. "Clifford Bass" wrote: Hi, If you are looking to add new rows, you can use the Paste Append option with either a table or a query. It will place the data starting in the first column, up through the number of columns that you have copied, if there are enough columns. So you should make sure that your columns match. Otherwise, you can highlight some rows that you want to replace. Or some columns. With columns it will start the replace at the top of the table. I would suggest you try it out on a copy of the table first. Or in a testing copy of the database. That way, if you mess up, you have not messed up the real data. Clifford Bass "gorilla" wrote: How do you avoid manually typing data in cells? I would like to cut and paste series data like in Excel. |
#6
|
|||
|
|||
Access cells
Hi,
It is based on a fairly different concept from spreadsheets. You can import your spreadsheets into Access instead of a copy and paste. I would suggest you take a step back and do some study about databases and Access. Here is a starting list of learning resources taken from a reply by John W. Vinson [MVP] to a question about learning Access: Jeff Conrad's resources page: http://www.accessmvp.com/JConrad/acc...resources.html The Access Web resources page: http://www.mvps.org/access/resources/index.html A free tutorial written by Crystal (MS Access MVP): http://allenbrowne.com/casu-22.html MVP Allen Browne's tutorials: http://allenbrowne.com/links.html#Tutorials Hope that helps, Clifford Bass "gorilla" wrote: I plan to try these suggestions. I need to learn more about queries, I was thinking that you had a table in Access, and had maybe a relationship with another table to then start running queries. Right now, I just opened up the program and it was just a grey screen. I wanted to paste some Excel data, and try to build a database. I was thinking Access was similar to Excel. Just a spreadsheet on Steriods as Jeff said. |
Thread Tools | |
Display Modes | |
|
|