solvingproblems
Technical User
How do you take an existing Microsoft xcel document and convert the file for use as a Microsoft Access database file?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
HOW DO YOU CONVERT XCEL FILE FOR USE WITH ACCESS
- Thread starter solvingproblems
- Start date
- Status
You don't neccessarily have to 'convert' - just do a FILE/ GET EXTERNAL DATA/IMPORT and navigate to where your excel file is stored. Change the "File of TYPE" combo at the bottom of the Import dialog to "Microsoft Excel(*.xls)" and go for it...
Jim Hare
"Remember, you're unique - just like everonone else"
Jim Hare
"Remember, you're unique - just like everonone else"
- Status
Similar threads
