Go Back   Access World Forums > Microsoft Access Discussion > General

Thread Tools Rate Thread Display Modes
Old 02-20-2017, 11:48 PM   #1
Dave 14867
Newly Registered User
Join Date: Jan 2017
Posts: 56
Thanks: 6
Thanked 0 Times in 0 Posts
Dave 14867 is on a distinguished road
Easiest way to import data into existing Template

Hello all,

I have a template that seems like it will work well as a starter for inventory control. I need to import my data into the existing tables to start using it, what is the easiest way to accomplish that? I just want to add onto the existing table entries.

I plan on using excel to create my data tables.



Dave 14867 is offline   Reply With Quote
Old 02-21-2017, 01:08 AM   #2
Super Moderator
Join Date: Feb 2013
Location: UK
Posts: 10,434
Thanks: 40
Thanked 3,367 Times in 3,262 Posts
CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice
Re: Easiest way to import data into existing Template

easiest way if this is a one off is to use Excel import wizard on the external data tab.

Open it up and follow the prompts

This assumes your table field names are the same as in excel and columns are in the same order
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Create Form to import data from excel template kambeng02 Modules & VBA 3 11-05-2012 08:16 PM
Command button to clear existing table and import new data from excel file jakobal Modules & VBA 8 01-11-2012 02:29 PM
Question Howto import data in related tables with existing records roi8877 General 1 06-02-2009 11:26 PM
Import Data into existing tables Johnrg Tables 3 03-04-2009 02:12 PM
Import some data to existing records? kate10123 Tables 1 01-30-2009 01:11 AM

All times are GMT -8. The time now is 07:32 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit

Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World