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

Frequently Asked 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'.

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.

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.

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.

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).

How can I use Excel's import feature to read signal files?

Frequently Asked Questions about PhysioNet
You can't, because Excel doesn't know how to figure out which of the many supported formats is used in any given signal file, because it can't understand any of those formats in any case, and because signal files are almost always orders of magnitude larger than any spreadsheet that Excel can handle. Spreadsheets are not suitable for studying, visualizing, or analyzing digitized signals; many better tools are freely available in PhysioToolkit.

Will duplicates be created when you import data?

Vaccines: CoCASA/FAQs
There should not be duplicate entries when you merge the data. The software will be set to merge using the VFC PIN# for the providers. As long as all users in a program use the same PIN for a provider, then the visit data will all be merged into one record for that provider. If different PIN numbers are used for the same clinic, then you will have duplicate entries that will need to be weeded out.

How do I import USGS streamflow or stage data into a Microsoft Excel spreadsheet?

Frequently Asked Questions - USGS Water Resources of North D...
Note: The following instructions are based on Microsoft Internet Explorer 6 and Microsoft Excel 2000. Commands may vary for other browsers and versions of Excel. There are many ways to import data into an Excel spreadsheet. One method is to use an Excel web query. The web query instructions refer to a sample file called SampleWebQuery.xls that may be downloaded. To download the sample file, right click on the underlined filename to the right, choose "Save Target As..

I am having trouble viewing the Excel Exported data in Excel 2000. Can you please help with this?

Business Valuation Market Data | FMV Faqs
If you are having trouble viewing the Excel exported data from BVMarketData.comsm and are using Excel 2000 (other versions of Excel have not exhibited this problem), please read the following. In the original version of Office 2000 there was a bug when passing Excel data over the web. This problem was fixed in a service pack released by Microsoft. Once you install this service pack update on your computer you should not have any trouble viewing the Excel data from BVMarketData.comsm.

Can I import my current Excel spreadsheet?

Productivity Software - FAQs
Yes, each component has a Import button which reads a standard tab-delimited text file which can be created from Excel. You can open any of the Sample Data files to see the column order and format for each column of data. You will still need to input other information on each record.

How do I import addresses from Excel?

StatTrak Address Manager FAQ
Click the Browse button and go to the directory location where the export file was saved and double click on the file Assign each column of data on your file to a field in StatTrak Address Manager and click the Import button. Click the Help button for more details.

How can I import addresses from Outlook / Excel?

SendBlaster - mail your list
SendBlaster can directly import addresses from Outlook Express; you can import data from other programs (including Outlook, Excel, etc.) after having exported them to .csv/.txt format (one record on each row, fields separated by comma, semicolon or tab).

U14) How do I import Invoices from Excel?

WinFactor Frequently asked questions
WinFactor allows you to import invoices from an excel spreadsheet. To import invoices, click on Advances from the main menu, then the Import button at the bottom of that screen. The spreadsheet must be in a specific format, do view a sample, click here. WinFactor tracks the number of people logged into the system in a file called wf30data.ldb. Sometimes, a user does not get cleared out of this file when they exit WinFactor.

Can I import my Excel spreadsheet into your resource?

Manage Your Cellar - Frequently Asked Questions
If you've been using a spreadsheet to maintain your wine collection, here is how you can import it into ManageYourCellar.com: Define the ManageYourCellar file import format by selecting "Cellar Import" on the left hand side navigation bar and then "Change your Import format" on the Import Cellar page. For example, you can choose the following import format:

Can I import data from a different version of CoCASA?

Vaccines: CoCASA/FAQs
All versions of CoCASA 3.0 and later allow user to import data from versions 2.1 and 2.0. (This is not a feature that was possible with earlier versions of CoCASA). However, users are unable to import data from 3.0 and 3.1 into older versions.

Can I import my own data?

LeagueWorks
Yes, use the AFTF Data Worksheet (a Microsoft Excel File) to format the data that is to be imported into the program. Once you are done formatted the data in the spreadsheet, press the "Export File" button to export the data to a Comma Separated Value (CSV). The CSV file then can be imported into LeagueWorks from the Import/Export menu on Startup window, or from the Data Utilities window.

Can I import data?

PokerDominator.com Support
Our Excel template. You can find this in the "Import Data" tab. Follow the instructions on that page. We have people who record all of their sessions on the template, then upload the template when they want to see their statistics and charts in Session Tracking. Some people find it easier to record their data on the template because they can just copy their session rows down and just change the date/time, buy in and cash out. Import .csv file export from PokerCharts.
More Questions >>

© Copyright 2007-2012 QueryCAT
About • Webmasters • Contact