Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 14th, 2004, 02:05 PM
Registered User
 
Join Date: Sep 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Import an excel file into access

Hi,
I would like to import the first line of an excel file into Access. If the values of the 3 cells(in the first lines of excel) match a certain condition then I would like to import the entire excel file.
Currently am able to import the entire spreadsheet but am unable to impose any condition before importing.
I was wondering if anyone could help me with the same to identify the cell values before importing.

Thanks,
Vaikkam
 
Old September 15th, 2004, 07:21 PM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 128
Thanks: 0
Thanked 1 Time in 1 Post
Default

Vaikkam,
Question? The values of the first row in 3 column in excel
spreadsheet file are those calculations. If it does,
when importing to access you can use the validation rule on access tables to restrict values imported. For example, in text:
In("Yes", "No").
John







Similar Threads
Thread Thread Starter Forum Replies Last Post
import excel to access Vision G Access 1 October 15th, 2008 02:12 PM
Import from Excel sheet to a text file zone Excel VBA 1 July 26th, 2007 10:34 AM
using vbscript in asp to import excel into access wpiass Access 11 April 26th, 2007 04:35 PM
Import Excel File to access database Komila ASP.NET 1.0 and 1.1 Professional 7 October 7th, 2006 12:45 AM
How to import Excel file to vc++ editor lokanadham Beginning VB 6 0 September 15th, 2004 05:35 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.