Go Back   Access World Forums > Search Forums

 
Showing results 1 to 1 of 1
Search took 0.00 seconds.
Search: Posts Made By: Ranman256
Forum: Tables 05-12-2017, 11:54 AM
Replies: 3
Views: 1,177
Posted By Ranman256
Re: How to import a file into database and split into two related tables

link the excel file as an external table.
build 2 queries. 1 for each table. put both queries in a macro.
then when you get a new file, overwrite the old one,
run the macro.
Showing results 1 to 1 of 1

 
Forum Jump



All times are GMT -8. The time now is 10:47 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


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