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. See similar questions...

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. See similar questions...

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'. See similar questions...

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. See similar questions...

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. See similar questions...

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. See similar questions...

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. See similar questions...

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. See similar questions...

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). See similar questions...

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. See similar questions...

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. See similar questions...

How much database disk space is required to store data from a typical text file?

PostgreSQL FAQ
an example, consider a file of 100,000 lines with an integer and text description on each line. Suppose the text string avergages twenty bytes in length. The flat file would be 2.8 MB. The size of the PostgreSQL database file containing this data can be estimated as 5. See similar questions...

How do I import data from programs like Word or Excel?

TaskMerlin Frequently Asked Questions (FAQ)
Select the File menu, click on Import and Export and select Import Documents to open the Import Documents dialog window. You can copy and paste two columns of data, which will create new tasks with the Summary and Content fields filled in. See similar questions...

How do I import names and addresses from an Excel file into ORCA?

ORCA Frequently Asked Questions
You can import contact information into ORCA as long as your Excel columns have the correct titles and order. First have at least one contributor name entered in ORCA and then export it using the method above "Can I print a list of contributors?" The list created will give you the column order and titles into which you will arrange your contacts in the Excel file to be imported. Once the Excel setup matches the CSV file format, save it to your desktop as a CSV file and you can import into ORCA. See similar questions...

Is there a way to import tag information from an Excel file?

faq_Software
Yes, our latest WindLDR version (version 4.10) has the import/export feature. You can both import and export tag information between WindLDR and an Excel spreadsheet. You will find this feature under the "File" menu in WindLDR. See similar questions...

Is it possible to import a Palm database or Excel file into SuperMemo 2000?

FAQ: SuperMemo Archive 2000-2002
you can import question and answer material from Palm SuperMemo to SuperMemo 2000 (for details see Palm FAQ) you can import question and answer material from Excel as long as you are able to export it in the standard SuperMemo format (i.e. with "Q: " and "A: " prefixes). For details see: File menu Unfortunately, SuperMemo for Windows is only available with an English interface. See similar questions...

Can I send you a Word / Excel / text file with a spec to quote on?

Aus PC-Market | FAQ
Please don't - the site lets you make your own choices easily. Use the site and select "send a quote" at the checkout. Just hit the "Buy" button for each item you want, and then go to the Checkout and select the "send a quote for confirmation" option from the "Payment Type" box, and we will get back to you with final confirmation, compatibility assessment, and pricing adjustments if required. See similar questions...

Explore Other Topics

How do I qualify for unemployment insurance benefits?
Q How do I renew my concealed weapon permit?
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 get a paid first-page ranking on Google?
Are DirecTV and Dish Network Satellite TV dish systems compatible?
What is tremor?
What type of Oil should I use in the Popcorn Machine?
What is on the horizon?
How can I level up my petpet?
What are the Nasdaq Trading Hours?
More Questions >>

© Copyright 2007-2012 QueryCAT
About • Webmasters • Contact