Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy CSV to variables
I have been using Excel VBA to open a CSV file, find the last row, and copy
data to an excel file. Once in the excel file using the .offset, I assign the cell values to a variable. Now that I have populated variables, I do an insert query against a SQL table. This works fine, but obviously I need to streamline the process. I would like to simply copy the values from the CSV directly into my variables, but not sure how to do it? Say the CSV file has 3 values separated by commas JIM,SMITH,1012223333 and I want to copy them to Variables with the names FNAME LNAME PHONE. Obviously I need to find the last row with data in it, and do a loop. Thanks for any suggestions. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Not at all clear on use of variables and/or object variables | Excel Discussion (Misc queries) | |||
variables | Excel Programming | |||
EXCEL FILE a copy/a copy/a copy ....filename | New Users to Excel | |||
How do I copy a range of cells in Excel using variables? | Excel Programming | |||
Looking up two variables | Excel Programming |