MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
View: 253|Reply: 3

import text numbers from excel to access giving a blank

[Copy link]

26

Topics

109

Posts

282

Integral

Conqueror

Rank: 3Rank: 3

Integral
282
Post on 2-9-2017 09:46:44 | All posts |Read mode
I  am new to access trying to import excel file to access but getting blank where cell '0123456
See attached yellow cell  get blank , i have 80000 rows to import
Any idea








  • testf.xlsx
    (14.2 KB, 1 views)
    Download








  • Reply

    Props Report

    2

    Topics

    36

    Posts

    108

    Integral

    Conqueror

    Rank: 3Rank: 3

    Integral
    108
    Post on 2-9-2017 10:13:31 | All posts



    Access will guess at the column types.
    If you add text to a number field,you get blank.
    What data type is the target field?
    Reply Support Opposition

    Props Report

    2

    Topics

    36

    Posts

    108

    Integral

    Conqueror

    Rank: 3Rank: 3

    Integral
    108
    Post on 2-9-2017 15:05:19 | All posts



    Access will guess at the column types.
    If you add text to a number field,you get blank.
    What data type is the target field?




    Reply Support Opposition

    Props Report

    26

    Topics

    109

    Posts

    282

    Integral

    Conqueror

    Rank: 3Rank: 3

    Integral
    282
     Author| Post on 2-9-2017 15:56:14 | All posts



    thanks
    I sorted it out, the issue was the target  field
    Reply Support Opposition

    Props Report

    Points policy of this forum

    Archiver|Mobile|Small dark house|Contact us|Excel Bar

    GMT-5, 11-18-2017 04:57 , Processed in 0.166487 second(s), 20 queries .

    Powered by Discuz! X3

    © 2001-2013 Comsenz Inc.

    !fastreply! Top !return_list!