Creating a temp Access table from MYSQL with 2 fabricated fields to be later linked to SQL Server to be filled. The 'fabricated' part is like
SELECT 1.0*0.0000 AS [field], 1.0*0.0000 AS [Field1]...... etc.
I use that particular syntax because I want the fields to be set as doubles, but Access insists on creating them as Longs - so when I update later with SQL Server I lose the decimal places (which are important because they are decimal times).
So basically - create a double via SQL in Access if that makes more sense.
My fallback is to issue separate ALTER TABLE statements which I was hoping to avoid.