Hi I am posting data from a mysql database to a remote access database via the odbc socketserver and the article found on this site. I am having a problem inserting data into fields in the access database because access allows for field names to have spaces and commas. I am not sure if i can change the field names but in the mean time does anyone know of a possible work around for inserting data when the field name has a space in it. for example:
INSERT into table (ID,Field2,Field 3) VALUES ('$id','$field2','$field_3')
Field 3 has a space within the name. Can i use a special asci character for the space or some entity so the data could be inserted correctly? If anyone has a idea please let me know.
Thanks,
Bart
INSERT into table (ID,Field2,Field 3) VALUES ('$id','$field2','$field_3')
Field 3 has a space within the name. Can i use a special asci character for the space or some entity so the data could be inserted correctly? If anyone has a idea please let me know.
Thanks,
Bart