csv import

  1. A

    Power Query editing csv import - saving query changes

    Hi All, I'm new here so i apologise if i'm not posting as needed - please let me know if not...Ive done a search of previous threads and cant find anything that i can use. Ok - so here's my scenario - I'm importing a csv file (its bank statements so i'll be doing the same process monthly) -...
  2. J

    Stop auto formatting csv file on import

    Hi. How do I get excel to not auto format my csv data to columns on import, without changing the *.csv extension to *.txt? I have tried to google an answer but did not find a solution. I would like all *.csv files to have to go through the "data to columns" wizard. THank you in advance, Jenny
  3. B

    Excel VBA importing multiple csv files from a folder

    Hi all, I'm very new to excel macros and VBA, but I am trying to write a macro capable of importing all .csv files from a folder into separate worksheets of a workbook. I wrote a macro for ImageJ that is able to produce a .csv data file for each image processed (these have a fixed number of...
  4. N

    Reading through the spaces

    I have a CSV that is received from another department that I pull into my workbook. One cell contains fractions and the inch mark followed by 17-24 spaces. I'm trying to pull from that cell to indicate what file I need to look in for the information and I'm not sure how the pull the...
  5. Z

    Pull .csV files into Database table Using VBA

    I have tried several different code changes to convert this macro code to pull in .csv files instead of .xls files. Can someone help me figure out how to make this work? All of the other forums that I have found do not provide a solution that works. Thanks in advance. Public Sub PullData() Dim...
  6. P

    Importing from Multiple CSV files into corresponding XL sheets using VBA

    Hi Board Members, I need help in creating a Macro which will help me to pull data from Multiple CSV files (text CSV as well as XL CSV, I mean different types of CSV) from a destination folder. The CSV file names can be stored in a separate sheet as a List. The code has to pickup file names...
  7. J

    Need to import a single cell value from thousands of csv - Without opening a dialog box everytime

    Hello guys :biggrin: I have a master spreadsheet with summaries, stats, and observations on about a thousand experiment results and ongoing. Each row corresponds to a unique experiment ID#. The instrument I use also generates a csv with the same name as the experiment ID#. I have tried several...
  8. C

    Macro to open CSV file ";" delimited

    Hi Excel Gods, I am looking to tweak below VBA code to be able to open X number of CSV file (; delimited) and to have the CSV file in the excel workbook as text (All columns). The current issue is that all the information per sheet are whitin one col thanks in advance Sub test() Dim...
  9. J

    Importing CSV issue/ find and activate

    I am trying to design a macro to automate importing a csv file. I currently put the filename without the extension in column A. I currently have the macro so it lets you choose the file first, then loops through column A to find that file name without extension. I want to offset by one column...
  10. S

    Error when importing csv file

    I have a macro that imports csv-files into sheets with the same name in a workbook. All the csv files end with ".csv" except for one file which ends with ".CSV". The macro is importing the csv files that end with ".csv" fine. But when it encounters the csv file with ".CSV" it adds a new sheet. I...
  11. R

    Import all CSV files from a folder into a single sheet

    Hi Was hoping that someone might kindly help me with the following. I found the code below for importing csv files into a single sheet and adapted it slightly. It works great except that if two files have exactly the same column it only keeps one of them while I want all the files imported as...
  12. S

    VBA - CSV import to Excel

    I've taken a code I've found by a google search and tried to implement it for what I need but I'm getting an error Subscript out of range error can anyone shed some light on why i might be getting this error? If you need any further information please let me known. I need the data to skip top...
  13. Fishboy

    VBA - Import CSV - Delimiter issues

    Hi guys, I have been working on a VBA macro to import a CSV file into Excel 2010. On the whole it has been successful with most CSV files however with one particular batch the first "column" looks like this item:45758:0:0:0:0:0:0 As such Excel is insisting on breaking the data up using...
  14. K

    Importing CSV Files from a folder

    Hi Everyone, I am trying to create a macro that will allow me to selected multiple CSV files in a folder to import into an EXCEL spreadsheet. The CSV files are already in an EXCEL worksheet after being downloaded from another database. There are four columns of data in each file that I want...
  15. B

    VBA code leads to #value! in cell but works in immediate box

    I have written a getprice function for retrieving stock tickers from yahoo and bitcoin prices from an online api. However the code for bitcoin results in an #value! in my excel cell. But it performs fine when I run the function from the immediate box in VB. I sense it's some sort of...
  16. U

    CSV file not importing unless opened and saved

    I have a macro that is supposed to import a downloaded csv file into a worksheet in my primary workbook. Currently, it only imports the csv file if it has been opened and saved before importing. I apologize in advance if this has been answered in previous posts, but I couldn't find the right...
  17. S

    Importing CSV files to Access

    Hello, I am trying to upload 100+ csv files into MS Access, I am a amateur in VBA, could i possibly have some help writing the code? The file location is, D:\Users\UKVIV00003\Desktop\Clients, the file format i need to import is csv, and i require all fields to be imported. Also, what is the...
  18. T

    Importing CSV Data into existing Access database

    I'm not very experienced with Access, but a client is currently using it as a basic CRM system. They are pulling in some sales data from Quickbooks to create an entry for products sold (using the Serial number as the unique identifier). Then we'll be getting a ton more data from a form on their...
  19. P

    import csv from web as utf8 and format column as text

    Hi! I have a piece of code that imports data from a database on the web. It works but the import uses the wrong encoding. Excel also messes up a column with id-numbers, starting with three zeros that are removed by Excel. How can a change my code so that it imports the data as utf8 and the...
  20. K

    Auto CSV to Excel to Word

    I am trying to use Excel as an interface between CSV files & Word using the 2003 version, the function of Excel being to properly format the data before import into Word. If anybody can suggest a simpler way, I would be happy to try. The process is as follows: - CSV files are updated every...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top