Does "INSERT INTO table FROM ARRAY arrayname" work with MS Access and/or SQL Server? If so what&#039;s the proper syntax. tried it in the format above, and I got this error..."Subscript out of range" <BR><BR>Stumbled across the concept of populating a table via an array, while browsing through the MSDN Library. It was listed in the Fox Pro section, and I was curious to see if it works anywhere else. <BR><BR>Don&#039;t know if this matters, but I&#039;m running the SQL in ASP page driven with VBscript.<BR><BR>Thanks,<BR>Lawrence