Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Excel spreadsheet to Access Database?


  • Please log in to reply

#1
Pacifics

Pacifics

    New Member

  • Member
  • Pip
  • 1 posts
Is there any way of converting a large excel spread sheet(which is basically acting as a simple database) into an actual Access Database?? Is it just going to be a case of spending weeks transferring the data or is there an easier way to convert?

Edited by Pacifics, 03 August 2009 - 08:38 AM.

  • 0

Advertisements


#2
dsenette

dsenette

    Je suis Napoléon!

  • Administrator
  • 26,019 posts
  • MVP
http://faculty.washi...mer/excel-c.htm

that site might help


from the excel help file:

  • Make sure the Microsoft Excel data is in list (list: A series of rows that contains related data or a series of rows that you designate to function as a datasheet by using the Create List command.) format: each column has a label in the first row and contains similar facts, and there are no blank rows or columns within the list.
  • Close the Excel workbook that contains the data you want to use in Microsoft Access.
  • In Access, open the database where you want to copy the Excel data.
  • On the Access File menu, point to Get External Data, and then click Import.
  • In the Import dialog box, click Microsoft Excel in the Files of type box.
  • In the Look in list, locate the file you want to import, and then double-click the file.
  • Follow the directions in the Import Spreadsheet Wizard.


  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP