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
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