Hi

Is this a one off import to a new table in SQL or something that will be run regulary adding data to an existing table?

Also will the data require validation before being added to the SQL table?

Reason for asking, that it would probaly be easier to use the Data Transformation package/tool in SQL Server to import the data to the SQL table rather than code it from the VBA side.

If it's going to be a regular job then you can schedule it too.