Importing Data from From Excel (.xls & .xlsx)

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER

Importing Data from From Excel (.xls & .xlsx)

Postby Nate1481 » Wed Aug 17, 2011 12:56 pm

I am frequently (daily or more) sent excel files from external sources with data I need to manipulate using a database (normally to match to internal or historic data in csv, tab delimited txt .xls or .xlsx).
From the in program help search the only way to get this into Base is to first open it in calc then copy an paste it, is there a better way?

Part or the issue is data validation, Access has import validation which is useful but not essential, but the size of a copy and paste is more often a potential issue due to the data set size since it's files of 100k+ lines with a dozen or more columns. Calc has just crashed 3 times trying to open a 46k excel file so I'm not filled with confidence.
OpenOffice 3.3 on Windows XP
Nate1481
 
Posts: 1
Joined: Wed Aug 17, 2011 12:16 pm

Re: Importing Data from From Excel (.xls & .xlsx)

Postby DACM » Sat Aug 20, 2011 2:08 am

AOO 4.1.x; LO 4.2.x; Windows 7/8 64-bit
Warning: Avoid embedded databases --> Solution: Adopt a portable 'split database' folder
Soli Deo gloria
User avatar
DACM
Volunteer
 
Posts: 1138
Joined: Tue Nov 03, 2009 7:24 am


Return to External Data Sources

Who is online

Users browsing this forum: No registered users and 1 guest