Paste from Microsoft Excel cells to Microsoft Access table successfully but…
When I perform a Paste Append into the table, the field I need that is a hyperlink is being truncated, thus link fails. How can I get the link to pates exactly as is from Excel?
Software/Hardware used:
Software/Hardware used:
ASKED:
March 25, 2009 10:51 PM
UPDATED:
March 30, 2009 1:11 PM
RELATED QUESTIONS
- How can I export from Notes to MS Access and have links function within Access taking you back to a Notes data page?
- I wish to have my macro copy a cell from a tab, then go to another tab and search specifically for the value of the initial cell.
- update powerpoint file links using vb.net
- Microsoft Outlook 2003 problem
- Microsoft Excel 2003 Macros
Answer Wiki:
If i understood correctly. You have some data in MS Excel which you want to move to MS Access and you are using Paste Apppend option. The issue you are facing is that link are getting truncated in MS Access.
Please check the type and size of field. You can change the field type of link to memo.
<a href="http://findsarfaraz.blogspot.com">MS Excel help</a>
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
