C celia2 New member Local time Yesterday, 20:38 Joined Nov 18, 2004 Messages 9 Jan 13, 2005 #1 Hi all, Can I transfer data from Excel to be stored in Access database? Is there any code or reference regarding this? Thanks, celia
Hi all, Can I transfer data from Excel to be stored in Access database? Is there any code or reference regarding this? Thanks, celia
N namliam The Mailman - AWF VIP Local time Today, 05:38 Joined Aug 11, 2003 Messages 11,695 Jan 13, 2005 #2 "simply" create an empty access database and import the excel file... You are only 5 mouse clicks away... no code needed Regards
"simply" create an empty access database and import the excel file... You are only 5 mouse clicks away... no code needed Regards
C celia2 New member Local time Yesterday, 20:38 Joined Nov 18, 2004 Messages 9 Jan 14, 2005 #3 What if only certain data from excel form are needed to be store in the access database? I created the excel forms for users to enter data then want to store the necsassary data into database for calculation purposes. Please help! Thanks, celia
What if only certain data from excel form are needed to be store in the access database? I created the excel forms for users to enter data then want to store the necsassary data into database for calculation purposes. Please help! Thanks, celia