I want to create a macro that asks the user which csv file they want to import (File/Open), then saves the data from the csv to a sheet in the current workbook. How can I bring up the file->open b...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_102...
1)how do I make a simple export of data from a report to a csv file to be viewed in excel, i would like to know the simplest way to do this.
2) My computer keeps bombing out when i run a certain...
http://www.experts-exchange.com/Programming/Languages/Pascal/Delphi/Q_10216679.html
I have this text file in csv format
here is a sample
name, price1, price2,price3...
name2,price1, price2,price3...
this goes on for 1000 columns and 2000 rows.
I want to read the data into ...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_10298751.html
Zones:
Visual BasicDate Answered: 02/24/2000 Grade: A Views: 0
Hi......
I have dumped a table to a text file from SQLServer 7.
Quoted, comma delimited, CR/LF row termination.
The thing is there are commas also in thesome of the fields themselves.
This scr...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10344978.html
Hi there!
I am trying to move records from F.csv into A.dbf.
I should move the record one by one.
After 1 record in F.csv is copied to A.dbf, I want to delete the particular record from F.csv,...
http://www.experts-exchange.com/Microsoft/Applications/FoxPro/Q_10824061.html
Zones:
FoxProDate Answered: 08/01/2000 Grade: B Views: 0
The real problem here is that I have a lot of data coming out on a report, which the user can click a button and open the report up in Excel, and do whatever they want. This works great for < 6500...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_20139519.htm...
Zones:
ASPDate Answered: 08/09/2003 Grade: B Views: 0
Connecting to Text-Delimited Database Files on the Fly
By Abd Shomad
--------------------------------------------------------------------------------
This article is a follow up to Abd'...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_20234709.htm...
Zones:
ASPDate Answered: 11/27/2001 Grade: A Views: 0
I have a nicely formatted Excel (97) worksheet, but the data is produced by another application in CSV format. How can I import the data from the CSV file to populate my worksheet so that all the e...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_202...
I'm at my wits end with this script that I'm using but unable to get it to successfully email the form results to recipient list. If you go to http://www.experts-exchange.com/jsp/qManageQuestion.js...
http://www.experts-exchange.com/Programming/Languages/Scripting/CGI/Q_20315991.html
Zones:
CGIDate Answered: 07/01/2002 Grade: A Views: 0
I am using a Microsoft Works Spreadsheet which does not have the Excel Import feature.
The CSV file is successfully imported but all the data is in Column 1. How do you ensure a new column is seq...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_204...
