Excel spreadsheet into Access - possible?

  goffer23 23:55 14 Jul 2005

I have an XL spread sheet from which I would like to set up a database. Is it possible to insert the info easily into an Access table without having to re-type it all? Abortive attempts so far! - there must be a way (isn't there?)

  lotvic 00:31 15 Jul 2005

found this that might work click here

TIP #10: BRING EXCEL DATA INTO ACCESS (Versions 7.0 & 97)
"""To bring data from a Microsoft Excel spreadsheet into Access, first open both programs and minimize Access.

Highlight the data in Excel that you want to import into Access. Point to the edge of the highlighted data, then ctrl/drag to the Taskbar and hold above the Access icon (DO NOT release the mouse button) until Access opens up.

Access will automatically import the data. """

  Simsy 06:57 15 Jul 2005

the "HELP" in Excel 2002;

Import Excel data to an Access database

1.Make sure the Microsoft Excel data is in list 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.

2.Close the Excel workbook that contains the data you want to use in Microsoft Access.

3.In Access, open the database where you want to copy the Excel data.

4.On the Access File menu, point to Get External Data, and then click Import.

5.In the Import dialog box, click Microsoft Excel in the Files of type box.

6.In the Look in list, locate the file you want to import, and then double-click the file.

7.Follow the directions in the Import Spreadsheet Wizard.

For more information about this wizard and Access, click Display Help after the wizard is finished.

I hope this helps,



  goffer23 10:41 15 Jul 2005

lotvic,Simsy,Rand Al Thor - thanks for your replies, problem now sorted. Found Simssy's method the most staightforward and worked a treat.
Many thanks.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 7 Pro review

Why Jeron Braxton mixes politics with Playstation visuals - and how he's already the 'world's best '…

iPhone XR 2019 release date, price & specs rumours

Comment faire une sauvegarde de son PC ?