transferspreadsheet problem

[tdubs]

Hi guys

Anyway to import a spreadsheet specifying the type of column to be imported

I have a excel table which have several column. In one specific column 90% percent of the data are integers. and the rest are characters.

But when I import the table to Access using the transferspreadsheet method, Access recognizes that column as numeric, so when there are characters it makes it blank or null.

Anyway to solve this problem???

Thanks in Advance, your help is much appreciatted

 

[DAW]

Is there not the option to change the excel column to text (if it is not calculated)?

 

[teabags]

What I did when I had this problem was I set the value of all fields being imported in my import specification to text. Then when I had all the values in access i seperated them with queries and made a new table with a union query followed by a make table query

 

[tdubs]

What I did when I had this problem was I set the value of all fields being imported in my import specification to text. Then when I had all the values in access i seperated them with queries and made a new table with a union query followed by a make table query

Ic how can i do that.. like setting it up to be imported as text

 

[teabags]

Go in to the advanced section of the import data screen and set up the import specification to import all fields as text

 

[tdubs]

Go in to the advanced section of the import data screen and set up the import specification to import all fields as text

Sorry, Can you direct me to that import data screen? Cuz I don't seem to find it... and could that be done by code or the option stays there when i save the file??? thaaaanks

 

[clerics]

this is a sample for you ! Try to take a look !
http://www.access-programmers.co.uk/forums/showthread.php?t=100365