Access cells

  • Thread starter Thread starter gorilla
  • Start date Start date
G

gorilla

How do you avoid manually typing data in cells? I would like to cut and paste
series data like in Excel.
 
gorilla said:
How do you avoid manually typing data in cells? I would like to cut and
paste
series data like in Excel.
Click to expand...

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.
 
.... 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
 
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
 
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.
 
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/accessjunkie/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
 
Back
Top