ExcelBanter - Numeric TExt Into SQL Server

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Numeric TExt Into SQL Server (https://www.excelbanter.com/excel-programming/393541-numeric-text-into-sql-server.html)

Candyman

Numeric TExt Into SQL Server

I am trying to import: `010608 from Excel into SQL Server. The code gives me
a 'Data Type Error' message.

I've tried setting the SQL Server data type to:
Varchar(7)
Char(7)
Text

HELP!

All times are GMT +1. The time now is 05:09 PM.