473,387 Members | 1,520 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Modifying Excel in Access

I am trying to create a program where I can import an Excel file into Access. My gripe is that I need Access to convert the Excel file into a table and be able to display it on the form but am having trouble with using VB. How do you automate the process of importing an Excel file into Access while keeping the same options as the Wizard. All of the files I will be using will follow the same process I use to import with the Wizard. But I want to automate it and be able to display that chart with scrolls on the form. Is there a feasible way to do this?
Jun 21 '07 #1
1 1477
I am trying to create a program where I can import an Excel file into Access. My gripe is that I need Access to convert the Excel file into a table and be able to display it on the form but am having trouble with using VB. How do you automate the process of importing an Excel file into Access while keeping the same options as the Wizard. All of the files I will be using will follow the same process I use to import with the Wizard. But I want to automate it and be able to display that chart with scrolls on the form. Is there a feasible way to do this?

Hang on!

Why are you importing??

Why not link tables - just link the access to the excel worksheet - As long as you have permissons to do so you can do just about anything?

If its not on your machine - ODBC it

Gareth
Jun 21 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Mrs Howl | last post by:
If I go through the normal key sequence for importing a text file and click on 'Advanced' so that I can bring up import specification files, and then try to add a couple of fields to the end of an...
8
by: mytfein | last post by:
Hi Everyone, Background: Another department intends to ftp a .txt file from the mainframe, for me to process. The objective is to write a vb script that would be scheduled to run daily to...
3
by: Mads Petersen | last post by:
I'm stuck in this code. Hope you can and will help me. I launch it from excel. I have made the following code work, but not as i whant. I need the ranges to be working with something like xlDown....
3
by: hari krishna | last post by:
hi, I am generating excel reports through vb.Net. After creating excel.application and the report is generated, each report leaves Excel in memory. I can see them in task manager in Process tab...
1
by: Laken | last post by:
Hello all, I am trying to edit hard-coded VBA links in Access and Excel applications. Is this possible using the .NET object model? If so, have you guys got any good material/references you...
1
by: garry.oxnard | last post by:
Can anyone help me to solve a problem which involves switching from Access to Excel (then back to Access) programatically please? I have an Excel template which, on open, also opens an Access...
0
by: Grip | last post by:
Hi, I have gone throught the group and Microsoft's online help and have seen many suggestions but I am still seeking clarity: 1. I have an excel spreadsheet. Column A contains text that may...
2
by: omakin | last post by:
I already designed a form to pull data out from multiple tables and present the data in a table format that was required. Now i need to go a step further by performing analysis, calculated fields...
16
by: Phil Stanton | last post by:
I have a form with a button which is supposed to open an Excel file (With lots of Macros /VBA) in it. The Excel file gets it's data from the Access program Here is the code Private Sub...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.