The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Linking Excel Files as Tables in Access

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Linking Excel Files as Tables in Access

Resolved · Low Priority · Version 2003

ReplyFri 19 Feb 2010, 13:44Delegate Hussein said...

Linking Excel Files as Tables in Access

Hello, I am trying to link an Excel file to the Database, unfortunate the first column of the excel file is blank/empty hence access is not letting me link the file (probably because it think that the file is empty), is there anyway I can force link. Unfortunate I cannot change the source data and the file gets update daily by an independent application. Many thanks Hussein

For upcoming training course dates see: Pricing & availability

ReplyTue 23 Feb 2010, 07:44Trainer Stephen said...

RE: Linking Excel Files as Tables in Access

Hi Hussein,

Thanks for your question

I'm afraid that the blank column will prevent the data transfering. Access can only import an Excel list or database, and this must consist of a contigous set of rows and columns.
It is however possible to write A VBA procedure to achieve your aims. Attending the VBA introduction course will give you the basic skills to do this

Regards

Stephen

Mon 1 Mar 2010: Automatically marked as resolved.

Access articles

· Access Corruption Avoidance Tip #2: Avoid Dangerous Data
· How To Use Tabs To Show Lots Of Related Data On One Form In Access
· Build International Databases With Microsoft Access
· An Introduction To Queries In Access
· MS Access Top Tips: Takeaways From Microsoft Access Advanced Training

Please browse our web site to find out more about
access+course and other Microsoft training courses.

Access tip:

Copy a Previous Record's Values to a New Record

If you often enter the same value in one field of a table, there are two methods to save re-typing the data.

1. Use Ctrl+' (apostrophe) to repeat the value input in the previous record.

2. Change the field's DefaultValue property in Design View to the most commonly used value.

View all Access hints and tips

What is the slide master used for ?

» Forum post: Powerpoint

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions