Hope this will help to import data from access database ( for more details type in the help )
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. --- On Fri, 19/9/08, Dragon -- Ruler of My Domain <[EMAIL PROTECTED]> wrote: From: Dragon -- Ruler of My Domain <[EMAIL PROTECTED]> Subject: [ms_access] Setting up a database for warehouse shipping and receiving To: [email protected] Date: Friday, 19 September, 2008, 5:50 AM I'm in the process of setting up a database to replace paper copies scheduling loads for shipping and receiving. I have forms for entering data already prepared, but I need to get the data 'out' in the form required. We have Excel speadsheets of the forms that the information needs to be put into, some change every 24 hours, others every 12. Is there a way to 'import' the form from excel to use in access, or export the data into the spreadsheet for printing? Thanks, Dragon Unlimited freedom, unlimited storage. Get it now, on http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html/ [Non-text portions of this message have been removed]
