Results 1 to 2 of 2
  1. #1
    stalk is offline Competent Performer
    Windows 8 Access 2003
    Join Date
    May 2014
    Posts
    143

    How to import text field as number from Excel without generating zeros or missing values

    After I import my data from excel to Access one of ID field is text so when I change that t number it is setting to zero. Any solution to keep it number because need to merge tis data on I field.
    Tried changing the format in Excel to number but after importin it is back to text



    Thank you,
    Lakshmi

  2. #2
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Here is a link to Import Specification

    https://www.datawright.com.au/access...text_files.htm

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 11-04-2019, 06:52 PM
  2. Import excel data to access with an auto number field
    By surfdragon in forum Import/Export Data
    Replies: 5
    Last Post: 05-03-2018, 05:34 AM
  3. Replies: 3
    Last Post: 08-11-2015, 05:35 PM
  4. Pad Text Field With Zeros in VBA
    By jhrBanker in forum Programming
    Replies: 9
    Last Post: 11-17-2013, 11:35 AM
  5. Replies: 4
    Last Post: 03-01-2013, 11:49 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums