Liveware Publishing Support Forum

Howdy!____I have parsed out a substring from a long field using the SUBSTR function into a new field that will be linked to another database of numeric codes later in my project. The problem is that when I attempt to join the other data source that has the numeric codes in it, the matching column do...

______O.K.____Got it...__Maybe I spend more time with the help menu__Thanks for the prompt reply...____

______This is actually a follow-up to an earlier post on text control files.__I have started to use control files - but can^t find which field controls where the output goes. If I want the users to preview the results before it goes to the printer - which field do I edit in the control text file ??_...

In the Help file, it sounds like an ASCII _text control_ file has fewer switches than a Dbase "control table:. In addition, the orientation is rows versus columns. My question is __does a text control file offer less control (i.e., fewer switches) than a control table for users who need to inte...

I certainly agree on that...____But right from the get-go (launch program / file new / blank report / Data Source Window opens with a prompt to "select a data source" with choices in the window) - Yes I can see a choice for MS Access Database file types but NO Excel. Am I missing something...

Another thought...____After I open the ODBC Data Source Administrator window - I do not see any file type for Excel under the "User DSN" tab but see a driver name in the "Drivers" tab in the same window??__Is there any distinction between how data tables are handled in Access2000...

I was able to connect to the Access2000 data table using User DSN tab then selecting "create new data source"...____However, my next question is: can I make a similar ODBC connection to an Excel2000 spreadsheet? I don^t see a choice other than several database file types...do I need to ins...

Actually - I never "hooked" into the remote Access data table. It is not a question of a bad query - it appears to me that some connection is not made so I never get past step #1. A short time after I posted the original problem, I hooked into the data table using the ODBC window - but now...