Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Append from Excel2.xls type xls 1

Status
Not open for further replies.
bs6600

bs6600

Programmer
Sep 23, 2005
57
GB
Most date fields in my Excel(2.1) sheets will not import.
If a date is calculated in Excel - it imports but if it's keyed it doesn't. (i.e A1 is a keyed date, B1 is =A1+1;B1 imports, A1 doesn't)
Field type in FP2.6 doesn't matter (Char or Date)

Please advise me.
 
Sort by date Sort by votes
Can you save your Excel worksheet as version 4? Both explicitly entered and formula-based dates seem to import okay from an Excel 4 spreadsheet, even in FoxPro 2.6 for DOS.
 
Upvote 0 Downvote
Thanks Rick - my first post and the answer I need within 2 hours - gold star!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Rajesh Karunakaran
  • Locked
  • Question
Does VFPxWorkbookXLSX work with old .XLS files? 1
Replies
2
Views
316
Rajesh Karunakaran
Rajesh Karunakaran
bs6600
  • Locked
  • Question
append from tab delimited - intersting effect (or bug)
Replies
14
Views
975
Chris Miller
Chris Miller
Filip Brnic
  • Locked
  • Question
Data type mismatch
2
Replies
25
Views
2K
Joe Crescenzi
Joe Crescenzi
Mike Lewis
  • Locked
  • Question
APPEND FROM problem 1
Replies
14
Views
537
Chris Miller
Chris Miller
Filip Brnic
  • Locked
  • Question
Automatically append last value + 1 into the textbox 1
Replies
12
Views
508
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top