CODEWITHSUNDEEP
sqlms-accessvba
jason m
jason m

Reputation: 6835

Create table with field type text creating as memo

the following

            "CREATE table " & acObj.pullTBLNAME & " ( DATES number,A Text, B Text, C Text, D Text, E Text, F number, G number,H number)"

is creating a table with data types of number and data types of MEMO not the desired type of TEXT.

any help would be greatly appreciated

Upvotes: 1

Views: 3954

Answers (2)

jason m
jason m

Reputation: 6835

Also,

  (DATES number, A CHAR,...)

works as well.

Upvotes: 0

Fionnuala
Fionnuala

Reputation: 91356

Specify a field size:

"CREATE table " & acObj.pullTBLNAME & _
" ( DATES number,A Text(20), B Text(255), C Text, " & _
"D Text, E Text, F number, G number,H number)"

Upvotes: 3

Related Questions