Import Spreadsheet

A

afs24

Board Regular
Joined
Sep 26, 2002
Messages
237
I'm trying to import this file from an excel file to an access database. I'm using the macro function but it's not working for some reason. This is how I wrote the location in the File Name section in the macro:

L:\QCKRESP\Vendor Operations\Summary Reserve On Hand Weekly OH

The L drive is mcssrv02. Would it be

mcssrv10:\QCKRESP\Vendor Operations\Summary Reserve On Hand
or
L:\QCKRESP\Vendor Operations\Summary Reserve On Hand
Weekly OH

Can I code this to make it easier? The table I'm importing it to is tbl_Pre. I need cells A1: F100 imported. Could you provide me with an example.
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
You must log in or register to reply here.

Similar threads

spacecaptainsuperguy
  • Question
Advice for linked files on network drive
Replies
0
Views
665
spacecaptainsuperguy
spacecaptainsuperguy
M
  • Question
Auto-Import XLS or XLSB workbooks with multiple sheets and append data to tables. (Access Tables and Excel Sheets = same name)
Replies
1
Views
2K
Manerlao
M
T
  • Question
Help converting Power Query that imports data to VBA
Replies
0
Views
546
The Shy Retirer
T
E
  • Question
Old XLSM files crashing Excel; looking for help to troubleshoot, please
Replies
9
Views
2K
jkpieterse
jkpieterse
MCLIFTO8
  • Question
Article / Guide feedback requested. The best way to learn Excel.
Replies
0
Views
1K
MCLIFTO8
MCLIFTO8

Forum statistics

Threads
1,221,552
Messages
6,160,462
Members
451,648
Latest member
SuziMacca

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top