importing excel

[gfrlaser]

This has me stumped of course. I have an excel data sheet containing 31,509 rows. Using Foxpro 9.0 to import, foxpro imports only 16,384 of the records. I thought at first the problem was foxpro, however when I tried to import the same sheet using a different program, the results were still only 16,384. What am I looking for? A control character? How can I figure out what is happening at record 16,383 so I know why it is stopping at that point? Thanks for any help.

 

[SkipVought]

You may have hit aa application limit
2^14 = 16,384
2^15 = 32,768
2^16 = 65,536 which is Excel's row limit (unless you're using 2007)

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[gfrlaser]

This makes a little bit of sense. I thought excel was limited only by rows (65000). Where did I hit this limit? More importantly, how can I know that will happen before I ever import data from the sheet. We get alot of excel files that we import from and I don't want to have this happen again. It was a major mistake losing that many records. Thanks for the reply.

 

[SkipVought]

Rather than an IMPORT, can you do a QUERY in FoxPro?

You application documentation ought to specify the limits.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[gfrlaser]

Query a database table after the import, sure. What I want is some formula or something that tells me before hand that my excel table of 31000 records will not be completely imported into any other application. All I can find so far on limits is the amount of 65000 rows. My 31000 rows is well within this limit. This never happened before. I hope I am being clear.

 

[SkipVought]

"Query a database table after the import, sure"

That's NOT what I suggested.

What's the purpose of IMPORTING Excel into FoxPro?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[gfrlaser]

We have to import the file from excel into our Mail manager program, there is no other way. It works on dbf files and does not read excel files directly. Also, any data manipulation required I can easily perform in foxpro. I have really studied this and it still seems not right. The excel table has 16384 rows and 22 columns, well within any parameters I can find. Should be importing just fine. Ok, I just exported the file in tab delimited format using excel 2007. I used a text editor to look at the data and found some that have " " around the fullname. this may be the problem however, when I view it in Excel, the quotes do not appear at all. Maybe this is where my prob lies?

 

[gfrlaser]

Sorry, quotes are not the problem. Thought I had it solved. Thanks.

 

[SkipVought]

Have you searched in any of the PoxPro Forums, as it seems to be a FoxPro problem and not an Office problem?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[gfrlaser]

Yep, searched it. If it was a foxpro problem only... then why did two different programs do exactly the same thing. Mail Manager 2010 imported the lower quantity as well as foxpro. Thats why it seems to be the Excel sheet that is a problem. I wish it had been that easy.

 

[JockMullin]

Some thoughts ...

How big is the Excel file in bytes?
Excel files often contain a lot of dead space due to past deletions, column formatting etc.

If you save the Excel spreadsheet as a csv, then import it into a new spreadsheet, save that in excel format under another name and try to import that into foxpro what happens? How does that excel file compare in size to the original?

DBF files can be corrupted by embedded garbage characters in fields, which may cause premature end of file. What happens if you delete rows 16380 thru 16400 and then try to import?

Jock