Data type to changed in Import (1 Viewer)

[Drunkenneo]

Hi,

this question i googled but unsatisfied results, please help me out:

I have excel, which i want to import in Access, but i need data type to get changed as text when imported, how can i do that?

 

[GinaWhipp]

Why not just set up a Temp table with the Data Types you want and import into the Temp table then push to Live table?

 

[Uncle Gizmo]

You have a bit of control with the "Import Wizard"

See YouTube Video :- http://youtu.be/ugTgG4TtHd8

And Screenshots:- https://docs.google.com/document/d/1SuyA_3H5f09XwJxL5Wb34C6h9oauRPP13XwfTRtfzNw/edit?usp=sharing (Slide 15)