Cut and paste from excel

[chauphs]

Hello all,

Need your help.
I have to build a data input form that
has 36 rows.
What can I use in Access to build this
input form that users can cut and paste
from excel worksheet.

Thanks in advance.

 

[josephwc]

Hello,

why and how often does the user need to cut data from excel into a Microsoft Access database. Are you carrying out an initial data dump of existing records from excel and you plan to use the input screen in Access in the future or is this going to be a regular occurence?

 

[chauphs]

It will occur often as users
receive data file and cut
paste into access form.

 

[PHV]

Have a look at the DoCmd.TransferSpreadsheet method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[fneily]

If you're cuting and pasting rows from an Excel spreadsheet into an Access table, are you then going to NORMALIZE the table that may produce more then one Access Table? If not, then you're not using Access properly. Access tables and Excel spreadsheets, though look alike, are structured differently. You probably have duplicate data. You won't have a relational database. I see this in almost every company I go to. A big no no.