right - I didn't want to edit the excel tables at all just wanted to create some data from it to work with in a separate MapInfo table. Data contains point information only.
Barbara ----- Original Message ----- From: "Cinda Graubard" <[EMAIL PROTECTED]> To: "Barbara H. Carroll" <[EMAIL PROTECTED]> Sent: Wednesday, April 07, 2004 10:10 AM Subject: Re: MI-L saving query to a separate editable table i guess you understand that you cannot edit excel tables? as a rule, i stay away from using excel tables in mi, other than saving them as native mapinfo tables. excel doesn't carry spatial objects, so the only way to map an excel data set is to use the explicit x and y. cinda At 11:01 AM 04/07/2004, you wrote: >ok did more digging and figured it out >thanks to all of you for your suggestions - I wouldn't have gotten it >without .. >this is what I did... > >went back to the original database - it was a MapInfo/excel file so tried to >open that.. >turns out the owner had locked the excel file - don't ask me why, it's >public data >so opened it in read-only mode in excel and saved it to a separate excel >file.. >then opened that in MapInfo and recreated the table - thank goodness x, y >coordinates were there >saved that file as a MapInfo file >created the query again and I can now save it as a dataset so I can modify >names and use it again later > >this was supposed to be a quick map... create a map with country/state >outlines with specific points pulled from the data base, make it pretty, and >give the created image to the client to include in a PowerPoint >presentation... > >Once again THANKS!!! > >Barbara >----- Original Message ----- >From: "Uffe Kousgaard" <[EMAIL PROTECTED]> >To: "Mapinfo-L" <[EMAIL PROTECTED]> >Sent: Wednesday, April 07, 2004 9:31 AM >Subject: Re: MI-L saving query to a separate editable table > > >A couple of wild guesses: > >Your table wouldn't happen to be a so-called "linked" table? That is a >kind of a view, involving 3 tab files on disk. Those are strange in some >ways. > >You could also try to save the result as a MIF file and see if that >works better. > >Or perhaps there are some meta data in the TAB file header that prevents >saving. > >Regards >Uffe > >----- Original Message ----- >From: "Barbara H. Carroll" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Wednesday, April 07, 2004 6:30 PM >Subject: Re: MI-L saving query to a separate editable table > > >ok next ... > >1. copy data to hard drive >2. change file attributes so they aren't read-only >3. recreate the query >4. try to save the query back to hard drive as the dataset 'test' >5. same error message "unable to create new table" > >this is weird > >Barbara > > > >--------------------------------------------------------------------- >List hosting provided by Directions Magazine | www.directionsmag.com | >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >Message number: 11314 > > >--------------------------------------------------------------------- >List hosting provided by Directions Magazine | www.directionsmag.com | >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >Message number: 11315 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11316
