[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference bump::msaccess

Title:	MSACCESS

Moderator:	BUMP::HONER

Created:	Tue Dec 01 1992
Last Modified:	Mon Jun 02 1997
Last Successful Update:	Fri Jun 06 1997
Number of topics:	1661
Total number of notes:	6339

1629.0. "how to: create macro" by SEAWLF::POISSON () Wed Feb 05 1997 14:26

    Hello Folks: 
    
    	I am trying to write a macro that will load a delimted text file
    into a table.
    
    How can I get the macro to 
    
    	ask the user to supply the filename for the file to be imported?
    
    	create a new table with a user entered tablename
    	
    	verify the success of the import
    
    Thanks for your help.

T.R Title User Personal
Name Date Lines

1629.1 Two out of Three NSIC00::KLERK Thunderbirds are Go Thu Feb 06 1997 04:34 12

T.R	Title	User	Personal Name	Date	Lines
1629.1	Two out of Three	NSIC00::KLERK	Thunderbirds are Go	`Thu Feb 06 1997 04:34`	12
	I have little experience with macros - prefer Access Basic any day for future maintenance and error catching - but I suppose you could do it by using the macro action TransferText (type ImportDelimited, TableName, FileName, HasFieldNames). The information for this action could be gathered via a form (action OpenForm) and should then somehow be passed on to the TransferText. I haven't got a clue how parameter passing is done in macros - it may well be this cannot be done. Theo

  I have little experience with macros - prefer Access Basic any day for
  future maintenance and error catching - but I suppose you could do it
  by using the macro action TransferText (type ImportDelimited,
  TableName, FileName, HasFieldNames).

  The information for this action could be gathered via a form (action
  OpenForm) and should then somehow be passed on to the TransferText.
  I haven't got a clue how parameter passing is done in macros - it may
  well be this cannot be done.

  Theo