Copy/Paste from Excel
I have two files that are attached. One is an excel and the other is access. My problem is I like to copy data from excel and paste them into the textbox1 and hit <Enter> to fill in the rest of the texbox2..texbox6.
I can only do this if all the cells are filled with data. If one of the excel cells are emply access does not move my data to the corressponding texboxes.
This is the excel spreadsheet.
Re: Copy/Paste from Excel
Since, your excel file is also linked to the Access database you may use and Append Query, using Excel Table as source and the Access Table as Target. This will transfer the data correctly to the Access Table.
|All times are GMT +5.5. The time now is 10:19.|