Question about Computers & Internet

1 Answer

I have a CD-ROM that contains 1 file. The file is in ASCII (text) Delimited Format with 3.2 million records with 526 megabytesin its current format. What relational database package can be used to setup and import the data

Posted by on

  • Mark Williams
    Mark Williams May 11, 2010

    Have you tried an on the web conversion table?
    "browse" the cd and click on convert.

    What you got to lose?

×

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 33 Answers

Assuming you mean that this file is tab delimited or something similar any relational database software should work fine. Some suggestions are Microsoft Access, MySQL, MS SQL and SQLite. There are so many others here is a link a list of others http://en.wikipedia.org/wiki/List_of_relational_database_management_systems

Posted on Mar 20, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How to export tally 9 to excel sheet


Hi,
Great question and there are two way export date. Please follow step by step instruction.
  1. In the Balance sheet screen click E : Export or press Alt+E.
  2. Select the required language from the list of Languages displayed.
  3. Select a format from the list of Formats displayed.
  4. By default, the exported file will be stored in C:\Program Files\Tally.ERP 9 for Windows 7 and C:\Tally.ERP 9 for Windows XP operating systems
  5. Press Enter to accept the default Output Filename or type the filename of your choice in order to save the file with a different name.
  6. Press Enter to accept the default Output Sheet Name.
  7. To update the existing file select Yes in Update Existing File.
  8. To format the contents of the file select Yes in Excel (Spreadsheet) formatting.
  9. Select Yes for the Field with Colour, to retain the background colour in the exported file.
And Second:
selecting the ASCII (Comma Delimited) format, the user can export all the reports or data from Tally.ERP 9. The data exported is converted to plain text separated with commas and stored in a file with the extension .txt. This file format is widely used for emailing and used for importing data into another company using Tally.ERP 9

More information please visit this link.
http://www.tallysolutions.com/website/CHM/TallyERP9/Data_Management/Export_Formats.htm

Thanks,

Jun 10, 2014 | HP Office Equipment & Supplies

Tip

BURNING X-BOX & GAMECUBE GAMES USING CDRWIN...


BURNING X-BOX & GAMECUBE GAMES USING CDRWIN
------------------------------------------------------
1) Insert your original in your CD-ROM.
2) Open CDRWin (or any other image extractor) to make an iso image of the game
on your hard disc. Click on 'Extract Disc/Tracks/Sectors'
3) Here are the settings which work for me (!):
Disc Image/Cue sheet
File-Format: Automatic
Reading-Options:
RAW, CD+G, CD-TEXT and MCN/USRC all Unchecked
Error Recovery: Ignore
Jitter Correction: Auto
Subcode Analyses: Fixed
Data-Speed: MAX
Read Retry Count: 10
Audio Speed: MAX
Subcode Threshold: 900
There are a lot of reports, that Raw reading also works, but I had problems with it enabled.
4) Click on 'Start'
--------------------------------------------------------------------------------
RECORDING TO A DISC
--------------------------------------------------------------------------------
1) Install Fireburner

2) Double click on the Cue File For The Game
3) Right Click And select burn To CD
That?s all there is record DAO, and you can try to burn it fast at 2X
Using PNY Black Diamond CDR'

on Mar 19, 2010 | Computers & Internet

Tip

Copy XBOX Games


Burning X-BOX & GAMECUBE GAMES using CDRWIN

1) Insert your original in your CD-ROM.
2) Open CDRWin (or any other image extractor) to make an ISO image of the game on your hard disc. Click on 'Extract Disc/Tracks/Sectors'.
3) Here are the settings which work for me (!):
Disc Image/Cue sheet
File-Format: Automatic
Reading-options:
RAW, CD+G, CD-TEXT and MCN/USRC all unchecked
Error Recovery: Ignore
Jitter Correction: Auto
Subcode Analyses: Fixed
Data-Speed: MAX
Read Retry Count: 10
Audio Speed: MAX
Subcode Threshold: 900
There are a lot of reports, that Raw reading also works, but I had problems with it enabled.
4) Click on 'Start'

RECORDING TO A DISC
1) Install Fireburner
2) Double Click on the Cue File for the Game.
3) Right Click and select burn to CD.
That's all there is record DAO, and you can try to burn it fast at 2x using PNY Black Diamond CDR'.

on Jan 20, 2010 | Computers & Internet

1 Answer

How do you format a cd


For windows 7:
1.Insert a disc into your computer's CD or DVD drive.
2.In the dialog box that appears, click Burn files to disc.
3.In the Burn a disc dialog box, type a name for your new disc.
4.Click Show formatting options, and then click one of the following formatting options:
-Live File System

-Mastered

5.Click Next to prepare the disc.

and for CD-RW:

1 Insert a disc into your recorder drive.

2 In My Computer, right-click your recorder drive.
The 'Use with DLA' option in the popup menu should have a check mark beside it. If this option is not selected, click on the HELP button and follow the steps in "Using DLA With Your Recorder Drive" before proceeding.

3 Click Format.
DLA's Format dialog box appears. The options available to you will depend on the type of recorder drive you have.

4 Set the options in the Format dialog box.
a ) Type a name for your disc in the Volume label text box.
b ) Select either Quick or Full Format by clicking beside the option you prefer. DLA can perform either a Quick or Full format of your discs.
c ) If you have an EasyWrite CD-RW drive, you will have the option to create an EasyWrite disc by placing a check mark beside Enable EasyWrite. (See Using DLA with EasyWrite Drives for more information.)

5 Click Start.
If you selected Quick Format or you selected Full Format and your drive supports background formatting, you will be able to use your disc within minutes. If not, you must wait until formatting is complete before you can write files to your disc.


I hope this will help you

Jul 30, 2011 | Computers & Internet

1 Answer

How do I delete the recordings on the vr5220 digital voice recorder? Step by step


To erase files or bookmarks, while playback is stopped:
1. Press x once.
2. Press '<< / >>' to select one of the erasing options:
  • Delete the current file (DEL 01)
  • Delete all files in the current folder (DEL AL)
  • Format the memory of the player (FORMAT) (Caution! All data inside the memory will be erased)
  • Delete all bookmarks in the current file (DEL BK)
3. With one of the above options selected, press and hold x for about 3 seconds to confirm your selection and start the deletion.
  • File numbers that come after erased one will be moved forward by one automatically.
  • Press to cancel erasing all files. The undeleted files are saved automatically.
  • Formatting the internal memory may be required when encountering compatibility problem, etc.
  • You may also format the player when connected to a PC (by right-clicking on the player's drive name or letter and select "Format" from the menu). Make sure you select FAT or FAT32 as the file system.

Jan 02, 2011 | RCA VR5220 Digital Voice Recorder

Tip

"BURN" YOUR FAVORITE "XBOX GAMES"


BURNING X-BOX & GAMECUBE GAMES USEING CDRWIN
------------------------------------------------------
1) Insert your original in your CD-ROM.
2) Open CDRWin (or any other image extractor) to make an iso image of the game
on your hard disc. Click on 'Extract Disc/Tracks/Sectors'
3) Here are the settings which work for me (!):
Disc Image/Cue sheet
File-Format: Automatic
Reading-Options:
RAW, CD+G, CD-TEXT and MCN/USRC all Unchecked
Error Recovery: Ignore
Jitter Correction: Auto
Subcode Analyses: Fixed
Data-Speed: MAX
Read Retry Count: 10
Audio Speed: MAX
Subcode Threshold: 900
There are a lot of reports, that Raw reading also works, but I had problems with it enabled.
4) Click on 'Start'
--------------------------------------------------------------------------------
RECORDING TO A DISC
--------------------------------------------------------------------------------
1) Install Fireburner

2) Double click on the Cue File For The Game
3) Right Click And select burn To CD
That?s all there is record DAO, and you can try to burn it fast at 2X
Using PNY Black Diamond CDR'

on Jan 03, 2010 | Computers & Internet

2 Answers

How can i export the data tally to excel


Hi,

There are 2 ways to do it..

Step 1
You can export as text and import it back to excel using the text file you created.
Or
You can select HTML and give the file name as eg-XYZ.xls


Step 2

You can export all reports and statements. For this a separate export button is provided in right hand button bar. To do this go to any report e.g. day book you to export or any statement e.g. balance sheet. You would see export button on top right hand side on button bar. Press it and a screen would pop up with export related options.

The first option is format of data to be exported namely ASCII, HTML, SDF, and XML. Which ever application you are importing this data in would decide in which format you should export the data.
For statements like balance sheets and trial balance which we use to send and import file in word and excel etc. HTML format is good. We need minimum formatting in this format while using it in MS Word and MS Excel.
certain applications accept continuous data where we have defined field length. Then ASCII format is better.
For application which accept SDF and XML format these formats can be chosen.

Give a file name and the exported file is saved in the parent Tally directory on your computer. You can now use that file to import its contents into another program, send it as it is (say if it is HTML file) to a colleague or view it using a browser.

Step 3

Consider exporting day-book.Go to day book press export button or use shot cut key Alt+E. Exporting screen will displayed.

tally-export-screen-300x82.gif

Press Back space on your keyboard. And select Format as ASCII (comma delimited). Now give output File Name as Daybook.csv, now select some other option you want to export from the bottom of the screen.

tally-export-ready-screen-300x81.gif

Press enter to accept screen. Day book is exported in to tally program folder. Check program folder for file daybook.csv,

csv-file.gif

Double click on it, the file will open in excel program. If you want it in excel work sheet file, use the option Saveas, and save it in Microsoft excel workbook (*.xls) format.



Hope this is helpful. Let us know if the issue is resolved.





*Rating and Comments are invited for this solution

Nov 24, 2010 | Tally T2245 Matrix Printer

1 Answer

I HOW I EXPORT TALLY 7.2 DATA IN EXCEL FORMAT


Hi,

There are 2 ways to do it..

Step 1
You can export as text and import it back to excel using the text file you created.
Or
You can select HTML and give the file name as eg-XYZ.xls


Step 2

You can export all reports and statements. For this a separate export button is provided in right hand button bar. To do this go to any report e.g. day book you to export or any statement e.g. balance sheet. You would see export button on top right hand side on button bar. Press it and a screen would pop up with export related options.

The first option is format of data to be exported namely ASCII, HTML, SDF, and XML. Which ever application you are importing this data in would decide in which format you should export the data.
For statements like balance sheets and trial balance which we use to send and import file in word and excel etc. HTML format is good. We need minimum formatting in this format while using it in MS Word and MS Excel.
certain applications accept continuous data where we have defined field length. Then ASCII format is better.
For application which accept SDF and XML format these formats can be chosen.

Give a file name and the exported file is saved in the parent Tally directory on your computer. You can now use that file to import its contents into another program, send it as it is (say if it is HTML file) to a colleague or view it using a browser.

Step 3

Consider exporting day-book.Go to day book press export button or use shot cut key Alt+E. Exporting screen will displayed.

tally-export-screen-300x82.gif

Press Back space on your keyboard. And select Format as ASCII (comma delimited). Now give output File Name as Daybook.csv, now select some other option you want to export from the bottom of the screen.

tally-export-ready-screen-300x81.gif

Press enter to accept screen. Day book is exported in to tally program folder. Check program folder for file daybook.csv,

csv-file.gif

Double click on it, the file will open in excel program. If you want it in excel work sheet file, use the option Saveas, and save it in Microsoft excel workbook (*.xls) format.


Hope this is helpful. Let us know if the issue is resolved.



*Rating and Comments are invited for this solution

Nov 10, 2010 | Tally T2245 Matrix Printer

15 Answers

Export tally data to excel format


Select ASCII. Give output file name Eg:d:/exp Open the file using EXcel.Select Delimite  nexxt comma finish.Export is completed

Jan 02, 2008 | Tally T2245 Matrix Printer

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

88 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

kakima

Level 3 Expert

101466 Answers

David Payne
David Payne

Level 3 Expert

14160 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...