Hello gurus, Any way to copy paste the records from
Excel to access at one go.I can't make this happen in access.Am I missing something?
Hello gurus, Any way to copy paste the records from
Excel to access at one go.I can't make this happen in access.Am I missing something?
Selected cells in Excel can be manually copy/pasted into Access table. The paste step requires first selecting the same number of table fields in row in Access table as selected in the Excel sheet. Never tried programmatically.
Why do you need this? Why not just import?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thanks for the quick reply.I just need to paste the values manually in the first 2 rows in the table so the values get automatically populated in the drop down of the 3 rd cell based on the pasted values.I need to check if they gets automatically populated when I import the values
I don't understand. Is this a regular process or a one-time effort?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
This is a regular process .Iam trying to get the records into the database first so that I can transform the state of the record using the pre populated values from the 3 rd column.The values from the drop down automatically gets populated based on the state selected.This is nothing but implementation of change management process in access database.I have built all that logic and looking if I can mass import or copy paste records
Let me try again - you need to transfer data from Excel just once then after that data entry will be by Access only? If so, do manual copy/paste or use import wizard.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.