Insert # into SQL server text datatype

JohnSeito

Active Member
Joined
Nov 19, 2007
Messages
390
Hello,

There is a ID or identification field that has either text or number. I want to insert this data into a char or varchar data type in SQL server.
How do I do it in VBA, can I convert the number into text and insert.

And how do I insert blanks into a number data type ? Please advise
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Watch MrExcel Video

Forum statistics

Threads
1,099,783
Messages
5,470,738
Members
406,719
Latest member
ensbana

This Week's Hot Topics

Top