Paste Data From Excel To Access Form

[fanzak]

Hi,
I would love to add a feature that let my users to paste the data from excel to access form. How could I implement such option?



It should give users a possibility to paste around 12 field values (in a single record) at once.

I know, there is an option for importing data from Excel to Access. However, my users sometimes use some random spreadsheets in excel for their own calculations, and it would save them a lot of time, if they could paste data directly from excel into access database.

Any ides?

Marcin

[ajetrumpet]

i know you can manually copy and past from sheets to access tables with good compatibility but I doubt you can do it with forms because forms are not actual spreadsheet objects, but rather the display screen

[fanzak]

Thank you Adam for your insight!

Well, I have found a way round Your post Adam, gave me thought of Sheets. You can give an option to the user to view the form in a Sheet View where they can freely paste the data from excel.

Thanks!