PDA

View Full Version : Works 4.5: copy spreadsheet to database



Scouse
15-10-2004, 12:40 PM
Hi Folks. I have a floppy containing 1500 records in an old .wks spreadsheet format. I want to transalate this to an equally old (4.5) .wdb database format so that I can sort it, print a variety of filtered labels etc. A straight copy and paste works for 14 of the 15 fields. However, the final in the spreadsheet is, for example 10/04, 14/04 and 07/04. Translated to the database these examples appear as 38087, 38091 and 38084 respectively regardless of which format I choose for the field. Any suggestions appreciated.

beama
15-10-2004, 01:05 PM
save as csv then import into the database application, open etc

godfather
15-10-2004, 03:27 PM
38087, 38091 and 38084 are the MS conversion of the dates that the original cells held.

Its also possible that these have transferred as text, therefore will not take on the cell attributes of a date.

Try multiplying them by 1 in another cell. If that works copy them back.

Works is not something I am familiar with, due to the many limitations of the package, so I cannot be specific.

Graham L
15-10-2004, 03:33 PM
That looks like a surprisingly successful transfer. :D

Before you get too carried away about the 15th field looking "wrong" (as in "different") try making a simple report and see what prints out.

If it's just dates stored in a different format, and they've been converted properly you might have complete success. :D

Scouse
16-10-2004, 10:12 PM
Hi there beama, godfather and GrahamL. Advice appreciated. Now have a nice little database with several associated reports and label files. Many thanks.

godfather
16-10-2004, 10:40 PM
Glad it worked?

However for the next person searching threads for a solution, its always useful to share just what you did from the suggestions to make it work.

Otherwise the thread is not going to help anyone else easily?