Summary: Instead of just opening the csv file in Excel, create a new Worksheet. Then: Data Get External Data Import Text File Show All Files Browse to the csv...
Summary: Hello, I have 'written' the following Excel macro. I have a .csv file that I want to import data from. The data within the .csv will change from time-...
Summary: Hello There, I am using excel 2000 to import some data from dbase. The data has two fields: 1. Item Description and 2. Quantity ordered on that part...
Summary: the email fields are missing after importing an excel or csv file to contacts. the field is populated in the file - just didn't populate the fields i...
Summary: Hi, I have two questions here. 1. I exported some data from one of the database and export file are text file. Then I tried to import to Excel, but I...
Summary: Basically, I need to create a way to take schedule data as a CSV, and make room schedules for individule rooms so they can be viewed and printed. So, ...
Summary: Hi We have a file on MSword using tables, and I want to export one of the column called email to excel so I can save it as a space format to import in...
Summary: file to be imported must be on a certain format. U can have a good format in copyin ur datas to excel and next save ur sheet as a csv one to be taken ...
Summary: Can software automatically import and export VB modules in Excel? I want to circulate some spreadsheets which, upon opening, would automatically impor...
Summary: Hi all, I'm using office 2003.i have 100s of xml files.I want to import that files in to excel.i dont want to import that files manually one by ...
Summary: I don't use Access any more and never used it much to begin with but, try opening and saving the .csv in Excel as a .xls file. Then you can import it ...
Summary: When using MS Access 97, I am trying to import a Office 2k .xls spreadsheet. I keep getting an error message when double clicking the file to be impor...
Summary: I am looking to import data from Excel to Access. The data is set up in one Excel file, but on 12 (monthly) sheets. After importing the first month/...
Summary: Could you kick the file out to a .csv instead? When you import a csv file in Excel, it will give you an option to format that row as text, and as a re...
Summary: Hi All, can anyone help me with this please. I have been importing tabular data from a website into a spreadsheet using web query. The data on the web...
Summary: Hello, I am importing text files(downloaded from the mainframe) to excel, and every time I am using the same copybook layout. These are text files wit...
Summary: Hi, I'm using Excel 2002 and I need some help. I have 30 text files (one for each day of the month) that I need to import into separate workbooks, and...
Summary: I'll be honest, I'm rubbish at VBA in outlook. The excel bit sounds pretty easy, you're just looping through the file and depending on the value in co...
Summary: Hello, can you please provide the code so that user can open text file and then that text file gets import to the in excel workbook ? i am using exce...
Summary: I'm looking for some help running an excel macro as an automated task. The macro is supposed to create a data connection, import some data from a par...
Summary: I import data from inhouse application to Ms Excel. The Ms Excel file created successfully. Then I try to open the Ms Excel file. The file open and th...
Summary: Hi i have a file which when created it was done with excel. It is a .xls file but when i open with excel it says " ive tried excel viewer to no joy is...
Summary: Hi, I am importing data to excel from dtabse.I want the date value to come as DATE in excel sheet cell.Currently it shows some numbers instead of d...
Summary: hi all. i have a graph in excel. now i want to draw a line horizontally from a value along the y-axis and where this line hits the graph i want to dra...