spreed sheet

[nashr1928]

I am using access 2003 and would like to put a excel spread sheet in a record text field on a form, but only for that record. Any idea's?

[rpeare]

I don't understand this question.

Are you saying you want to copy a current cell in an excel spreadsheet into an access table? If not you'll have to be more clear as to what you're trying to do.

[nashr1928]

Sorry I'll try to be more specific. Normally outside of access I can just copy the contents of a spread sheet and paste into notebook or word. I want to do this to a specific record of a forms text field. Am I making ant sense?

[rpeare]

so, when you have an access form open, you want to be able to export the record you're on to a spreadsheet? (the entire record, not a single field of that record)

[nashr1928]

Actually the opposite. Want to import the contents of a spread sheet into a text field of a form.

[rpeare]

Which application(s) do you have open when you want to perform this copy? Just Excel, Just Access, both of them?
Do you want to copy the entire row of data from excel to access?
do you want to copy just one cell from excel to access?

Are you copying to a table? a form? be as explicit as possible the short answers aren't really helping

[nashr1928]

This is what I want to paste into the text field.

[rpeare]

that's not cutting and pasting, that's importing data.

Is this a one time import (i.e. are you creating a database to replace your spreadsheet) or is this an ongoing process (i.e. you have to do it every x many days)

[nashr1928]

No, this is only one time and I was only refering to cut and paste as an example. Just this once and only on one record. I have had the same database for about 3 years.

[rpeare]

if you are cutting and pasting one record (row) from an excel spreadsheet into access you can just use the shortcuts (ctrl-x, ctrl-v) to cut and paste it into your table. Just highlight the row you want to copy in your excel side (or the cells) cut and paste into your table (assuming it has the same number of columns