Jun 14 2004, 03:55 PM
I need to import specific cells from an excel spread sheet to a table in Access 2000. Is there a code to do this?
Jun 14 2004, 04:18 PM
Have you tried the Link Table option in Access?
This will link in the entire spreadsheet and you can append the data from that link to another table?
let me know if you need more info.
Jun 14 2004, 05:51 PM
DoCmd.TransferSpreadsheet acImport, , stDocName, "c:\access files\pv.xls", True, "A:D"
note the end has all of colum A through D chosen. You should be able to place in what you want there. like A1:B4 and soforth
Jun 14 2004, 06:09 PM
Would you do this via creating a new Macro or Module within Access?
Jun 14 2004, 06:31 PM
I have it in a form to import on a click of a command button. You may be able to find the macro version of it, but I do not know. I do not like macro's prefere to run VBA it makes the size smaller and faster.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here