Ask Your Question
0

Import access tables into LO. [closed]

asked 2014-11-17 03:10:24 +0100

Peter B. gravatar image

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.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-06 04:21:41.428016

1 Answer

Sort by » oldest newest most voted
1

answered 2014-11-17 07:05:19 +0100

MQ-818 gravatar image

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.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2014-11-17 03:10:24 +0100

Seen: 685 times

Last updated: Nov 17 '14