P PL Jul 30, 2009 #1 I wish to move/ export or copy an Excel spreadsheet into Access for Query analysis, what is the best way to do so? Thank you
I wish to move/ export or copy an Excel spreadsheet into Access for Query analysis, what is the best way to do so? Thank you
O OssieMac Jul 30, 2009 #2 I think that the easiest way is to import to Access. Open up Access, create a new database then lookup 'External Data' and/or 'Import' in Help and there is ample instructions on how to import Excel (or spreadsheets).
I think that the easiest way is to import to Access. Open up Access, create a new database then lookup 'External Data' and/or 'Import' in Help and there is ample instructions on how to import Excel (or spreadsheets).
