Linked Excel Table

[jtrombley24]

All,

In an Access 2010 database I have a linked Excel table from which I create a local table with using this query:

SELECT DISTINCT Batch, Material, [Document Date], MIN([Posting Date]) AS Posting_Date INTO Ship_Data
FROM mb51_link
GROUP BY Batch, Material, [Document Date];

I would like to specify my data type via SQL as the table gets created. Is this possible with something similar to this?

CAST([Document Date] AS DateValue)

Thanks!

 

[Joe4]

Better way of doing it.
Set up a blank table shell the way you want, which your field names, types, and properties.
Then instead of using a Make Table query to create a new Table, use an Append Query to write the records to the pre-designed table shell.