Covert Text to number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi - I import a text file which is saved as text and i need to convert that
text field in the table to a number field. Is it possible.?
 
if the only data in that field is numeric, then yes. you can set the data
type in the Import Specification; if you're importing the data to an
existing table, set the data type in the table's field to match the Import
Specification.

hth
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing Text Files Into Access 1
Append Geocode Data from Text File (via Query) Not Working 3
Losing long numbers regardless of format 2
MS ACCESS 2013 Long Text filed filter by another tables Long text field 1
Importing .xls to Access data type problem 2
Importing Long Numbers as Text cells 1
Number Data Type Unavailable 1
Import from iSeries400 1

Back
Top