Import Data into Microsoft Access from Microsoft Excel, CSV Files, and Fixed-Width Text Files

Поділитися
Вставка
  • Опубліковано 24 лис 2024

КОМЕНТАРІ • 16

  • @ShrutitPatel
    @ShrutitPatel 3 роки тому +4

    I have Learned all my Access Skills from you. You are amazing sir!

    • @599CD
      @599CD  3 роки тому +1

      Great to hear!

  • @omarbearmtz1
    @omarbearmtz1 2 місяці тому

    I have an Excel file that has more than 255 fields. But, I only need certain fields. Is there a way to do that without manipulating the excel file?

  • @benardhiseprian3348
    @benardhiseprian3348 3 роки тому

    Thank you very much for the lesson, you're so amazing !! i learn many things from you.
    One thing I want to ask, how to create like a template in access table field? due the data field i import from csv data is > 100 fields and need to replace everyday into the database (this condition make me need to set data tipe again while i import from CSV file into the access database)

    • @599CD
      @599CD  3 роки тому

      I don't understand

  • @colinraynor833
    @colinraynor833 Рік тому

    I would also be interested in EXPORTING. Specifically to CSV with the intent to import into Google Calendar.

    • @599CD
      @599CD  Рік тому

      This is already on my list. Stay tuned.

    • @colinraynor833
      @colinraynor833 Рік тому

      @@599CD I can work with that ! Thanks. Just my own thoughts..The Fields Google MUST have are specific. Therefore a way to alter existing verse google update/append/cross query or whatever you think works best may be a thought.

  • @shahinalwathaifi321
    @shahinalwathaifi321 2 роки тому

    Hi love your videos, thanks a lot. I was trying to import an excel xlsm file and I'm getting "The wizard is unable to access information in the file C:\Documents....\filename.xlsm. Please check that the file exists and is in the correct format." I would really appreciate the help thanks. I'm a biggener, by the way,

    • @599CD
      @599CD  2 роки тому

      I can't tell what's wrong from here. Sorry.

  • @MrRomeo785
    @MrRomeo785 3 роки тому

    what if is there are many cells before the start of the excel table?

    • @599CD
      @599CD  3 роки тому +1

      Clean em up. :)

  • @Shopmix-cj8vu
    @Shopmix-cj8vu 2 роки тому

    Hi, Does anybody knows how to change the letters codification page to make the importation? I have some tables here but some letters are imported wrong. I need to change to some codification that accepts to portuguese letters. I would be glad if someone can help me. Thanks!

    • @599CD
      @599CD  2 роки тому

      Sorry, I'm English only.

  • @ehteshamshah
    @ehteshamshah 2 роки тому

    R/Sir I Shall be very thankful if u please show the vba code to me (as I m ur old fallower) to get data from text file. A single line data stored in text file.

    • @599CD
      @599CD  2 роки тому

      That's covered in the Extended Cut for members. 599cd.com/Join