Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to automatically map Excel columns to Access fields during import?
The advance button should be in the lower left hand corner of the import window. First goto New Table, then select the file to import, once the import window comes up go through the import process then before clicking the finish button click on the advance tab. Then goto the save as button to...- daveg232
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
INSERT INTO statement (data not showing correctly)
this probably isnt it but the Dim dtBillingMonth isnt set- daveg232
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Table is read only (but it's not!)
I've written an application that imports and reformats data. Its works great on every computer ive tryed it on, except of course the ONE computer that needs it. The error im getting onthe computer says "The table is read only" or something to that effect. Ive tryed everything i can...- daveg232
- Thread
- Replies: 0
- Forum: Microsoft: Access Modules (VBA Coding)
-
How to automatically map Excel columns to Access fields during import?
Try importing the file yourself, but before closing the import window click the advance button. From here you can make whats called an Import Specification (I think thats what its called) this will allow you to create a specific format to import your excell sheets. To make the correct fields go...- daveg232
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
