Tricky one

[stanl]

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.

[stanl]

My fallback is to issue separate ALTER TABLE statements which I was hoping to avoid.