Help! I need to Split a memo field
Quote:
> I created a web based survey using an HTML form and I am automatically
> saving the data into Access 97 via an ODBC insert. The database is
> extremely simple, and consists of one table. I do not have any of the
> following: Forms, Queries, Macros, or Modules. After the data is saved into
> Access, I am going to grab it into another application (SPSS for Windows)
> via ODBC. SPSS is a statistics package and it will be used to analyze the
> data. The problem is as follows.
> In the survey, there are five open ended questions which are saved into
> Access as five memo fields. SPSS, unfortunately, can not read in a string
> variable longer than 255 characters. It simply takes the first 255
> characters and chops off the rest. Please don't ask why, but it is
> essential that these comments end up within SPSS (nothing like a mean or
> medium on a comment).
> Therefore, in Access I need to create three new fields that are 255
> characters wide for every memo field. Furthermore, everytime a record is
> added via an ODBC insert Access should automatically populate these fields.
> I am not sure how to accomplish this. Is there a way to create a query that
> runs everytime a record is inserted (AfterInsert perhaps)?
> TIA
> /freud
> ps. Please email me directly
There are two ways I can think of. In 97 you can "overload" a function
and therefore do sometype of "afterupdate". It would be hard and
complex. A better suggestion would be to programiticly split the memo
into fields of 255 chars when "downloading" to SPSS. Assuming you are
writing to the file instead of "transfertext" .
--
<------------------------------------------------->
Programmers Inc and SPD | Smart Product Development
David Eholnikof, cc | Fax 905.272.4838
902 - 2100 Sherobee Rd | Phone 905.272.4015
Mississauga, Ontario | suburb of Toronto
