Loading CSV File Using DataAdapter With ODBC Command

I'm having problems loading a csv file using dataadapter with ODBC command. Here's what I have:

Dim conn As OdbcConnection
Dim dt As New DataTable
Dim da As OdbcDataAdapter
Dim connectionString As String
Dim iFileRecords As Int32
[Code] .....

I get the following error:
"ERROR [42000] [Microsoft][ODBC Text Driver] Syntax error (missing operator) in query expression 'CAST([Preferred Phone Number] AS varchar(30))'."

The reason I was trying the CAST([Preferred Phone Number] AS varchar(30)) AS PNo was:
If all of the Phone Numbers are added with spaces e.g. 086 1234567, it works using SELECT [First Name], Surname, [Preferred Phone Number] AS PNo FROM [" & Me.ImpFileName & "]"
but if they are without i.e. 0861234567, it doesn't work hence trying to use CAST.

My guesses are to either force the import process to treat the [Preferred Phone Number] as text or get the CAST expresion to work but I've failed on both counts! I've tried the command in SQL database (albeit using SQL rather than ODBC connection) selecting from a table using CAST and it works fine.