Results 1 to 43 of 43

Importing CSV as table

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,946

    Importing CSV as table

    Hi,

    i have data in csv and want to import databodyrange (replace) to table in my main workbook.
    How can i do this?

    csv file:
    Screenshot_27.png

    Main Workbook:
    Screenshot_28.png

    I think that i have to somehow:
    1. open csv file
    2. transform data to a table
    3. get table databody range
    4. Copy to main workbook

    how can i do this? Maybe there is a built in method to import csv as table?

    Please help,
    Jacek
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. CSV file is importing as a Table
    By dagindi in forum Excel General
    Replies: 0
    Last Post: 06-26-2017, 11:41 AM
  2. Scraping/Importing Table
    By Madskillet in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-10-2016, 07:34 PM
  3. Importing table from Web
    By nkyg1985 in forum Excel General
    Replies: 0
    Last Post: 07-11-2013, 10:51 AM
  4. importing multiple csv into 1 table
    By saimike in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-19-2011, 03:36 PM
  5. Importing a PDF table into Excel
    By zapp7 in forum Excel General
    Replies: 5
    Last Post: 05-25-2010, 02:21 PM
  6. Importing Access table as it is.
    By sspandit in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-26-2009, 04:34 AM
  7. Importing An Awkward Table
    By hackett1867 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-23-2008, 08:13 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1