800 records were stored in an access database, but they were converted to excel. I need to export the data from excel to access. Does anyone have advice.
Thank You
Printable View
800 records were stored in an access database, but they were converted to excel. I need to export the data from excel to access. Does anyone have advice.
Thank You
Rather than exporting the data from excel you have to import it into access, open access and go to file > get external data > import a window will open looking for access files, under the files of type part at the bottom change the extension to .xls, now select the spreadsheet you want to import, the import tool that appears next will let you choose what worksheets or data you import into your new table.
RB :)
I simply copy rows from Excel and paste into Access. Works fine.
A third option would be to open the destination database and right click in a blank area of any database object (tables, queries, etc) and from the shortcut menu select import, navigate to your Excel spreadsheet and select whatever it is you want imported. Remember, Access like clean, unformatted data for trouble free imports.........
Hope this helps...........