Henk, I am just using the Excel sheet to import data into SQL express.
Using Excel as a database with the SQL Connector in Diafaan SMS Server is not a very good option, it is far better to use a real database like Microsoft Access or Microsoft SQL Server (Express). The SQL Connector is quite strict with regards to the data type of the database fields and this can be a problem with Excel and text files.
I was wondering if you could post a sample Excel sheet to clarify some issues I have. I am sorry, I am not that well versed with SQL and every time I try to load a sample file to SMS server, I get a whole lot of errors including I didn't match the character numbers with the ones required by the table.
Most Users Ever Online: 494
Currently Browsing this Page:
Guest Posters: 518
Newest Members:, Henk Helmantel
Administrators: Henk Helmantel: 1003