G Guest Jan 30, 2005 #1 Im trying to convert soem excel files into access to make it easier to work with. How do I go about doing that.
Im trying to convert soem excel files into access to make it easier to work with. How do I go about doing that.
J Joseph Meehan Jan 30, 2005 #2 Byrone said: Im trying to convert soem excel files into access to make it easier to work with. How do I go about doing that. Click to expand... Make sure the Excel file is arranged properly (first row = Access Filed Names: Data in rows under the field names, each row will become a new record.) Start Access. "File" "New" (name your new Access file) "File" "Import" Select Excel from the drop down file type menu. Find and select the Excel File.
Byrone said: Im trying to convert soem excel files into access to make it easier to work with. How do I go about doing that. Click to expand... Make sure the Excel file is arranged properly (first row = Access Filed Names: Data in rows under the field names, each row will become a new record.) Start Access. "File" "New" (name your new Access file) "File" "Import" Select Excel from the drop down file type menu. Find and select the Excel File.