Hi, I'm trying to import some FoxPro files into SQL Server 2000. I
don't have access to FoxPro, they just zipped up the files and sent
them to me.

I haven't been able to figure out how to import the files directly
into SQL Server 2000, it keeps saying that the data is in an
unexpected format. I am, however, able to create linked tables in
Microsoft Access, and then import the majority of the information from
Access to SQL Server 2000. That even gives me the text and memo
information.

The problem that I am running into is that one of the tables is too
large. Access gives me the message "Record is too large", and all of
the fields populate with #Error. I tried to run a query on the table
to cut down on the size, and I get the same error. I tried to import
the query into SQL Server 2000, and got the "Record too large" error
again. I think that the size issue is coming from the .fpt file, but
I need to use that information, so I can't just leave it out. I tried
to import the query into SQL Server 2000, and got the same error that
Access had given me.

Does anyone have any ideas on how to go about getting a really large
table into either Access or SQL Server 2000?

Use the import feature in enterprise manager.

If they are old fox tables, then use the free table driver in the ODBC
section

Otherwise use the Visual FoxPro driver and specify a dbc.



"Liz" <lhillring (AT) bowmansystems (DOT) com> wrote

Hello, "me" !
You wrote:


One other possibility with Access is that you have too many
indexes. Access is limited to 32 of them. Not sure if SQL has
the same problem.

--
Cyrus Welch
Senior Programmer
MetSYS Inc
http://www.metsysinc.com

I had a similar problem. I had to get the OLEDB FoxPro Driver that
comes with Visual FoxPro 7.0. I use that in my DTS package and I can
upload files perfectly. You might see if you can get your hands on that
driver.