Question about Microsoft Business & Productivity Software

2 Answers

Steps in saving file in excel to database

I have file in excel that I want to transfer to database

Posted by on

2 Answers

  • 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
  • 57 Answers

If you want to transfer in MS Access database follow this steps
1. open access database blank or existing database
2. in table view click file then select import
3. under import select link and look for the excel file you want transfer
4. select the recommended steps
5. once you created the excel link
6. you can copy this link into access table
7. you have now transfer your excel into database

if you want to transfer your excel file into other databases such as oracle, ms sql, my sql.. you need to sql tool i suggest to use Toad tools for database where you can download for free those tools for different database.

Posted on Dec 16, 2008

  • Level 1:

    An expert who has achieved level 1.

    Welcome Back:

    Visited the website for 2 consecutive days.

  • Contributor
  • 2 Answers

Severals solution :
- save file as text separated by comma and use sqloader from oracle
- use function in excel to concatenate insert order : "insert into TABLE_NAME (field1,...,fieldn) values (A1,B1,...,??n);". Save file as text with sql extension. Connect against roacle db and execute file previously saved.
- use ODBC from MicroSoft

Posted on Dec 12, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

5 Answers

Excel sheet has been lost how to recover


Lost Excel file can be recovered from:
  1. Recycle Bin - If you have deleted the file with normal delete.
  2. Backup - If have maintained the backup of file.
  3. Email - It may possible that you have mailed the file to someone.
  4. 3rd Party Recovery Software - Recuva, Stellar Data Recovery ...

Oct 29, 2012 | Microsoft Office Excel (License Only)...

1 Answer

HOW TO TRANSFER TALLY ACCOUNTS DATA TO EXEL SHEET


HI,

Please follow below step

Step 1. Open Tally

Step 2. Open Report Which is you want Transfer in Excel.

Step 3. Press CTRL With E (Ctrl+e) from keyboad

Step 4. Select Sharped Sheet or Excel

Step 5. After type location for file save like this D:/your folder name/

Step 6. After You type file name with xls. like this sales.xls

thanking you

davevipul197

Dec 19, 2010 | Business & Productivity Software

2 Answers

How we protect the excel sheet by password.


follow these steps to password-protect Excel file
Step 1: Save your *.xls Excel file Point to the File Menu, click save as and input the file name then the *.xls file is saved on your local disc. Point to "Tools" - "Options". When the "Options" multi-tabbed dialog box appears, click the "Security" tab.
Step 2: Choose the password protect type • If you don't wish other users to view your Excel workbook, enter a password in the "Password to open" box, and then click OK.
• If you agree other users to view your Excel workbook but don't want them make changes to the workbook, type a password in the "Password to modify" box.
• If you wish to use a different encryption settings type, click Advanced, choose an encryption setting type you want in the list, and then click OK. And you can also specify the number of characters in the Choose a key length box.
Step3: Confirm your password After type your password, a "Confirm Password" box will prompted, retype your passwords to confirm, then click OK.
Step4: Resave the Excel spreadsheet. After password protecting your Excel file, click Save. All the steps are finished.
read more: http://blog.recoverlostpassword.com/how-to-password-protect-microsoft-office-excel-2003.html

Dec 09, 2010 | Microsoft Office Standard 2007: Windows

2 Answers

Can i convert cash register express data to excel and the to qb


certainly. most reports have a "save as excel" option once you generate them (at least, the full sized ones). CRE does have a direct QB interface however that is prob easier. you can also run direct queries off the database itself and save the results of those as an excel file.

Feb 02, 2010 | Pc America Restaurant Pro Express

2 Answers

Please give me detail steps involved if you were able to successfully use this mehod to convert files....


Say you got tons of Excel sheets, PowerPoint presentations and Word documents on your computer that were written in Office XP or 2003. How do you convert all these files to the new Office 2007 format. One option is that you open all of them in the associated Office program and manually save them in the newer (docx, xlsx or pptx) format. Or follow these steps and convert all documents in one go.
Step 1: Download Migration Manager kit and extract it into a new folder – say: c:\office.
officepack.png
Step 2: Download and install the Office Pack – this step is required even if you have Microsoft Office 2007 already installed on your computer.
Step 3: Assuming that you extracted the Office Manager files in c:\office directory, go c:\office\tools, open ofc.ini using notepad and add the following line.
fldr=c:\users\labnol\documents
This refers to the folder location that holds your office files. I am pointing this to my Documents folder but it could be different on your machine.
Step 4: Open command prompt and go to c:\office\tools. There you’ll see a utility called ofc.exe – this is the Office File Converter that will convert all old Office files to the new 2007 Office document format in bulk. Run.
convertdocs.png
Immediately all old Office files in that folder (and sub-folders) will get converted to the new format and are saved in a new folder.
This utility works with Word (doc to docx), Access databases, PowerPoint (ppt to pptx), Visio diagrams, Excel (xls to xlsx) and Microsoft Project files. The conversion may however fail for password protected documents.

Nov 20, 2009 | Microsoft Office 2007 Basic for PC

1 Answer

Call/Link a Report from another access 2007


Access can only work with one database at a time.
You'll need to either export the data you need and import it into your current database or save it in an external format like Excel or CSV file that you can access.

Aug 03, 2009 | Microsoft Office Access 2007 for PC

1 Answer

How to connect my database to my project?


use Excel library at following location.

D:\Program Files\Microsoft Office\Office12\EXCEL.EXE
Microsoft Excel 12.0 Object Library

Jan 05, 2009 | Microsoft Office Standard for PC

2 Answers

Microsoft Access database


try creating (if you have not already tried) the exact folder tree as [I:\DESKTOPPC\DesktopPC\Database\Toby3]. Now put the file "Tonys_work_be.mdb" into the folder named "Toby3".

Dec 12, 2007 | Business & Productivity Software

Not finding what you are looking for?
Business & Productivity Software Logo

Related Topics:

263 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18298 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...