Results 1 to 2 of 2
  1. #1
    tzmyo is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2013
    Posts
    1

    Access table linked to excel - field size problem

    I have to create a access table linked to an excel sheet in which some columns contain texts and some contain number(without decimals). In access table, fields size of columns that correspond to columns containing numbers in excel are set to "double". But I need that fields to be in "long integer" as I need to export that access table to a third party software where only columns with text and "long integer" values are accepted. Any way to set the column format in excel so that they will appear as "long integer" in access? Thanks.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Apparently not. I think Access insists on using the most accommodating number type when linking, so any number type entered to the spreadsheet will be allowed. This is probably because Excel doesn't have number types, just formatting.

    However, importing allows designation of other number types. Your best bet is probably to import into table, do what you need to with data then delete table or just purge the records and use table for the next import.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 2
    Last Post: 03-20-2013, 04:25 PM
  2. Repost: Dates shifting between access and linked excel table
    By lucasjkr in forum Import/Export Data
    Replies: 3
    Last Post: 11-14-2012, 03:08 PM
  3. Excel Import field truncation problem (to Access Memo field)
    By jhrBanker in forum Import/Export Data
    Replies: 6
    Last Post: 07-27-2012, 08:52 AM
  4. Replies: 6
    Last Post: 05-16-2012, 12:43 PM
  5. Replies: 1
    Last Post: 04-25-2011, 12:36 PM

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