Import access tables into LO

[PeterB2]

How do I import MS Access 2010 tables into LO? I can do an ODBC link, but cannot save the tables. Cannot even highlight them then copy and paste.

[MQ-818]

Export the table as EXCEL or DBF file.
then import the (copy paste) EXCEL/DBF into base if you have same field names.
Watch Video’s at www.TheFrugalComputerGuy.com
He has base video’s that shows how to import EXCEL files into base.

EASY WAY IMPORT EXCEL/DBF IS

1. Create BASE (ODB) Stay at the TABLE area
2. Open EXCEL/DBF file
3. Do a Side by Side (left BASE / right EXCEL) view
4. DRAG just the EXCEL-TAB into BASE TABLE area
5. Import WIZ will start; Make sure choose right Field types and Header
   make sure go thru all the screens, I wouldn’t press FINISH at once.
6. Also don’t forget to Assign Primary Key (Record_ID) etc.

Hope this helps…

Good Luck.