QueryCAT Logo
Search 5,000,000+ questions and answers.

Frequently Asked Questions

How do I import data from Excel or a comma-delimited text file?

Plan family, military & class reunions with Reunion Plan...
In Excel, make sure your columns have data in the correct order (press F1 for Help while in the Import screen and it will tell you the correct order) or click (or right-click) here to get a sample Excel file as a template (erase the header and sample rows after adding your data). Leave any columns blank where no data exists (look at the Alumni Information Screen using the Demo Reunion to match up the Excel Columns with the fields on the screen).

Why do you provide the data in both comma delimited ASCII text and Microsoft Excel formats?

The CID Registry of California - Contact 39,000 plus CIDs (C...
Originally, our databases were provided only in comma delimited ASCII text. A couple of years ago we added the Microsoft Excel format because we wanted you to be able to see the data immediately and become familiar with the content. Most relational database management programs allow you import the data either from either the comma delimited text file or the MS Excel file.

What is a Comma Delimited File (CSV)?

NARA - AAD - FAQ
AAD allows you to retrieve your search results in a comma-separated format. Comma separated files are sometimes known as comma delimited, comma separated value, or CSV files. This simply means that a comma separates the individual pieces of data so other programs can import the database and correctly handle it. Nearly every application designed to handle data, such as most spreadsheet and database applications, can import and display comma-separated files.

How do I parse a comma-delimited (CSV) data file?

Frequently-Asked Questions about sed, the stream editor
Comma-delimited data files can come in several forms, requiring increasing levels of complexity in parsing and handling. They are often referred to as CSV files (for "comma separated values") and occasionally as SDF files (for "standard data format").

How do I output my spreadsheet data as an ASCII, delimited text file?

Documentation/FAQ/Calc - OpenOffice.org Wiki
In the Save as dialog that appears, select File type Text CSV (.csv; .txt) from the list of spreadsheet file types. In the Export of text files dialog box that pops up, enter the field and text delimiters of your choice. The Text delimiter is the character that will surround any text entries in your spreadsheet, to keep each phrase together as an entity, when the file is exported into ASCII format.

Can I convert a comma delimited file into a table after I've uploaded it to FirstClass?

FAQs
Yes - through an undocumented feature: shift-click on a text file attachment that is either comma or Tab delimited and you will get a table. Click on a column header and watch it sort.

How to import data from Excel?

Online Spreadsheet Software - i-Spreadsheet
Data can be imported from Excel through the Import Excel Module . This button will come up when you log on as administrator. To log on as administrator, first click the button at the bottom of your spreadsheet. Then enter your admin password in the right most part of the page and hit enter. Next you will see several new buttons and drop down menus appear. Click the one called 'Import from Excel'.

How do I import data from an Excel spreadsheet?

dQuery
this time, dQuery does not import column headings from Excel. In Step #8, you will need to have the exact names and column letters of the headings from the Excel spreadsheet in order to map the fields. We recommend printing the first page of the Excel spreadsheet so you will have them in front of you. Set ‘Start Cell’ to A2 (since we are not importing the headings) and ‘End Cell’ should be K397. Next. At this time, you need to know what the columns in Excel are.

Can I import the data into Microsoft Excel?

Anonymous Feedback: FAQ
Yes, raw data in the CSV format can be imported into Excel. This works without any problems. Try it by logging in as user "demo" with the password "demo" and generating a raw report. If one of your respondents associated a password with his response and decided to edit it one or more days after first entering it, it is no longer included in the response count for the date of its creation, but for the day when it was last modified.

I have data in plain text (.txt) file, can I import this data in to exam (.exm) file?

Exam Software Test Engine
Yes, you can use "Import" utility to import the data from plain text (.txt) files to exam (.exm) file. Import utility is very useful for customers who already have their data in electronic form. Convert you existing data into plain text (.txt) file and use "Import" utility to import into exam (.exm) file.

Can I download your data into an Excel file?

Rich's - California Business Leads - FAQ
All data is exportable to a "CSV" file, (comma separated values), which is compatible with all the major database programs and CRM applications such as ACT, Goldmine, SalesForce and others.

How do I copy data into an Excel file?

Newport Strategies - F.A.Q.
the top of each screen where tabular data is presented is a Print/Copy drop down menu. Selecting Copy from this menu allows the data to be pasted directly into Excel. The copied data is presented in a tabular format.

Can I import text data from my database?

Print Studio 2E FAQ
Yes, Print Studio allows you to import text data from Microsoft Access, Excel, FoxPro, text files, or any ODBC/OLE DB compliant database such as Microsoft SQL Server, Oracle and MySQL.

How do I import/export data/reports from/to Excel?

FAQ about apm
From "APM" you can export reports to text files, then you can convert these files to the Excel format from Excel. To import ".txt" or ".xls" files in to ".apm" files you need the special utility.

Can I export and import data from MS Excel?

Inspection Management Software, RBI Software, Corrosion Soft...
Yes. Most Credo data can be exported into Excel, Word or Adobe PDF format. You can also create your own custom report templates. As an alternative to using Dataloggers you export thickness inspection data to Excel and then after the survey has been completed you can import the thickness readings back into Credo. Excel is an ideal medium if you are using a third party inspection team to carry out your inspection activities.

I need to create a comma separated file (.csv) from a SAS data, what should I do?

Maryland Population Research Center...
Q: How do I change default SAS System user profile folder in SAS 9.0? For example, I want to set the working directory to c:\mysas. The best way to do this is to change the -sasuser parameter in the sasv9.cfg file. Just set this in sasv9.cfg from your computer and you are ready to go.

My text exports from ACCESS and Excel didn't import properly. What do I do now?

LIBRARY CONCEPTS - Library Automation Systems
Microsoft products do provide text (ASCII) export features. (To create Exports in Excel, Save As "Comma delimited - CSV". In Access use the Save As/Export|External File|Save As - TXT, CSV...) However, they do not create the "standard" ASCII structure that PC Card Catalog is expecting. Their exports do not enclose fields containing spaces with quotes. That can make for pretty random field assignments during the PCCC import (Item Entry|Import|ASCII).

When using comma delimited ColdFusion lists, why are empty elements ignored?

CFFaq.com
ColdFusion lists are not CSV comma-delimited lists and do not behave as CSV lists do. ColdFusion ignores empty list elements, so ListLen("a,b,,d,e") will return 4 (not 5), and ListGetAt("a,b,,d,e", 5) will throw an error. To convert a ColdFusion list to a CSV list, use Replace() and replace all ",," (comma comma) with ", ," (comma space comma) - a space is a valid list member value and ColdFusion will not ignore it.

Q2: When saving numerical data from Excel, the decimal separator is comma. Is that a problem?

Frequently Asked Questions
Windows software is, by default, using local decimal separator, which is comma in Finland, Germany, France and Italy, and point in UK, USA and Japan. In-house software is mainly assuming decimal points. S1: Change the decimal separator from comma to dot in Windows or in Excel. S2: Use the latest versions of dft2html or dft2html to convert data files into XHTML table format and import those in Excel.

Explore Other Topics

How can I find out about Unemployment Benefits?
How do I apply for a permit to carry a concealed weapon (gun permits)?
How do I calculate how many Miles are required in order for me to redeem a reward ticket or upgrade?
What is the difference between a brown bear and a grizzly bear?
How do I dispose of latex paint?
How can I improve my page ranking on Google and Yahoo?
Are DirecTV and Dish Network Satellite TV dish systems compatible?
What else causes tremor?
What type of Oil should I use in the Popcorn Machine?
How do I find a participating Horizon Direct Access provider?
How can I level up my petpet?
What are the Nasdaq Trading Hours?
More Questions >>

© Copyright 2007-2009 QueryCAT
About • Webmasters • Contact