UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Importing Multi Value Field To Ms Access, Access 2016    
 
   
bugoysnipes
post Aug 23 2019, 06:37 AM
Post#1



Posts: 1
Joined: 23-August 19



Hello, I am new in access and VBA programming and I am finding a way to import to a multi value field in access. Is there a way without separating it to a multiple table or normalize my table.
Go to the top of the page
 
DanielPineault
post Aug 23 2019, 07:20 AM
Post#2


UtterAccess VIP
Posts: 6,959
Joined: 30-June 11



MVF are to be avoided like the plague!!!

You may like to review a similar thread on the subject: https://social.msdn.microsoft.com/Forums/of...forum=accessdev

--------------------
Daniel Pineault (2010-2019 Microsoft MVP, UA VIP, EE Distinguished Expert 2018)
Professional Help: https://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: https://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 
GroverParkGeorge
post Aug 23 2019, 07:23 AM
Post#3


UA Admin
Posts: 36,017
Joined: 20-June 02
From: Newcastle, WA


Welcome to UtterAccess.

First, you should be aware that many seasoned Access developers avoid Multi-Value Fields, at least in part because they are harder to work with--as in this case.

What is the source of this MVF? Where are the values coming from? Is it another table in a different Access database that is originally also an MVF?

I suppose one can do this, but we really ought to consider the need or desirability of it as well.

Once we have a better picture of the actual data sources and values, perhaps a fuller answer can be offered.

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    11th November 2019 - 05:56 PM