| View previous topic :: View next topic |
| Author |
Message |
superdairyboy
General User
Joined: 09 Jul 2005
Posts: 25
|
 Posted: Wed Sep 29, 2010 7:16 pm Post subject: Creating a dBase file from a Calc file |
 |
|
Ok I'm using OO 3.1.1
We have a spread sheet with headers. We want to create address labels from the data in the file.
As I understand the 1st step is to create a dBase file. File - New- Database. I've done this. Followed the Wizard. However it is only saving the 1st 13 lines of the spread sheet. I've done this in the past and not had problems.
What am I missing here? |
|
| Back to top |
|
 |
JohnV
Administrator
Joined: 07 Mar 2003
Posts: 8981
Location: Lexinton, Kentucky, USA
|
| Posted: Thu Sep 30, 2010 8:10 am Post subject: |
|
|
| Do a Save As from the spreadsheet and select dBase as the file type. Use File > New > Database, bullet Connect to Existing Database, select dBase below then navigate to the file's directory. All dBase files in that directory will become registered data sources. |
|
| Back to top |
|
|
superdairyboy
General User
Joined: 09 Jul 2005
Posts: 25
|
| Posted: Thu Sep 30, 2010 9:42 am Post subject: |
|
|
Ok I've got it figured out. Still not sure why it was only saving the 1st 12 lines but I got it to work
Thnaks |
|
| Back to top |
|
|
Silhouet
General User
Joined: 02 Sep 2010
Posts: 10
Location: The Netherlands
|
| Posted: Thu Sep 30, 2010 10:23 am Post subject: |
|
|
| JohnV wrote: | | Do a Save As from the spreadsheet and select dBase as the file type. Use File > New > Database, bullet Connect to Existing Database, select dBase below then navigate to the file's directory. All dBase files in that directory will become registered data sources. |
That's a nice trick, Thanks |
|
| Back to top |
|
|
|
