#1 08 Apr 2020 14:52

fjlara
New Member
Registered: 08 Apr 2020
Posts: 1

MSAccess 2003 VBA DoCmd.TransferSpreadsheet acImport,

Good morning when I import Excel file to my MDB
this is on excel
3/27/2020    37786    E-0724/20A    0000827    4    SERVICIOS ADMINISTRATIVOS INDUSTRIALES, S. DE R.L. DE C.V.    15540.94

when I import to MDB appear

Date                            CTA    TRAFICO            PEDTO    CliNum    CLIENTE                                                                                             IMPORTE
3/27/2020    8:40:54 AM 37786    E-0724/20A    0000827    4            SERVICIOS ADMINISTRATIVOS INDUSTRIALES, S. DE R.L. DE C.V.    15540.94

the Date appear with time but I don't need it.

I am use the procedure

DoCmd.TransferSpreadsheet acImport, 8, _
             "CuentaMex", stDocName, True

please help me.

Offline

Board footer

Powered by FluxBB