Sorry it took so long to respond, I got pulled out of the office all of yesterday.
I suspect that you are doing your DTS import your DSN is set to use a VFP database. In this case when you see the table list SQL is retrieving it from a list of tables stored in the VFP database. The VFP database information is stored in a set of 3 files, ?.dbc, ?.dct, ?.dcx where ? is common among the files. This container holds neat things like triggers, defaults, referential integrity and so on. However, having said that, it is possible to create VFP tables know as "free tables". These are tables just like ones in the database but are not linked to any database. There are a few restrictions (no triggers, column names < 10 characters, etc) but otherwise these tables can be accessed just like tables that are part of a VFP database. So my thought is that the 3 sets of files you are not seeing in your import list are free tables. Create yourself another DSN telling the system to use tables instead of the database. You should now see all of the tables in the folder, both the ones that are part of the database and the ones that are not. You should be able to select all of the tables you want to import. Hope that helps. ______________________________________________________ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com ______________________________________________________ > -----Original Message----- > From: Tony Weeg [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 01, 2003 8:45 AM > To: CF-Talk > Subject: RE: visual fox pro db? > > > just missing a table in the import, that is there, in the foxpro files > directory.... > does this make sense? I have like 55 groups of 3 files, all I assumed > where 55 different > tables with some ancillary files to hold data....correct? so, most of > them import fine, its just > that a couple, don't? its like they are not there in the > list of tables > to choose from, on my > dts import...ive got the filename dsn working, its all good, > just three > tables don't show up in > the list to select all when importing into sql server 2000? > > tony weeg > uncertified advanced cold fusion developer > tony at navtrak dot net > www.navtrak.net > office 410.548.2337 > fax 410.860.2337 > > > -----Original Message----- > From: Bill Grover [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 01, 2003 7:52 AM > To: CF-Talk > Subject: RE: visual fox pro db? > > > Tony, > > We use FoxPro here all the time and have successfully migrated many > systems to SQL. What is the issue/errors you are seeing? > ______________________________________________________ > > Bill Grover > Supervisor MIS Phone: 301.424.3300 x3324 > EU Services, Inc. FAX: 301.424.3696 > 649 North Horners Lane E-Mail: [EMAIL PROTECTED] > Rockville, MD 20850-1299 WWW: http://www.euservices.com > ______________________________________________________ > > > > > -----Original Message----- > > From: Tony Weeg [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, July 01, 2003 12:05 AM > > To: CF-Talk > > Subject: RE: visual fox pro db? > > > > > > and then in turn, im builing a web based collections > system, reverse > > engineering actually...but building from scratch most of > it...taking > > it from a windows based app > > to a web based app :) fun fun fun...old vfp system!!! > > > > later. > > > > and thanks for any help.. > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Sent: Monday, June 30, 2003 11:56 PM > > To: CF-Talk > > Subject: Re: visual fox pro db? > > > > > > What's the question? > > > > -Novak > > > > ----- Original Message ----- > > From: "Tony Weeg" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Monday, June 30, 2003 8:46 PM > > Subject: ot: visual fox pro db? > > > > > > > hey, if anyone on here is knowledgable about vfp > databases...please > > > if you have time, email me off list, i have a quick > > question...thanks! > > > > > > ....tony > > > > > > tony weeg > > > [EMAIL PROTECTED] > > > www.revolutionwebdesign.com > > > rEvOlUtIoN wEb DeSiGn > > > 410.334.6331 > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
