J Jackie Oct 29, 2003 #1 Hi! Is there anyway to import or copy data from excel spreadsheets into access? Thanks!
D David Oct 29, 2003 #2 -----Original Message----- Hi! Is there anyway to import or copy data from excel spreadsheets into access? Thanks! . There are a number of ways. A quick way is in the Click to expand... control source of a text box enter =dde ("excel","sheet1","r1c1") r1c1 is row 1 column 1
-----Original Message----- Hi! Is there anyway to import or copy data from excel spreadsheets into access? Thanks! . There are a number of ways. A quick way is in the Click to expand... control source of a text box enter =dde ("excel","sheet1","r1c1") r1c1 is row 1 column 1
S SueM Oct 31, 2003 #3 Yes, in access click file, then get external data, then change the file type to excel and select your file and follow the prompts. You can also do it using vb with the TransferSpreadsheet action.
Yes, in access click file, then get external data, then change the file type to excel and select your file and follow the prompts. You can also do it using vb with the TransferSpreadsheet action.
