On 2009 Oct 15, at 14:58, Ron Carr wrote:
If you use Excel 2007 64K record limit disappears.
I agree .dbf format is best.
Using Excel some formats can change, like zip codes can become
numeric and lose leading zero, if your zips have one: I am in
Northeast where they are all leading zeroes.
What version of Access? I can give you detail instructions.
Some ancient thing, circa 2000, I think. It didn't say anything about
DBF as an export option, but it DID give me 5 different flavors of
Paradox. I settled for tab-delimited text, which is my preference,
anyway. Now it remains to be seen if everything imports OK into FMP.
I was not previously acquainted with Access's "Yes/No", "Binary", and
"Memo" data types, so we'll see how they turn out. At this point, I'm
just doing a test import, so I expect to be learning a few new things
shortly.
The good news is that whoever designed the Access database obviously
had no sense at all of how relationality worked, so there are only 3
tables worth mentioning, they're not linked to each other, and even
the largest of them has only about 25 fields and 5000 records, so if
necessary I could do a lot of hand-adjusting (not that I WANT to, of
course, but it's not outside the realm of possibility).
I suppose it's possible that Microsoft has improved this piece of
crap thru the subsequent years, but I wasn't able to get it to do
something as elementary as printing me out a field list. Sheesh.
