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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Using Access auto-number with import file
Hi all, I'm using an Access Auto-number field in a table as no combination of the other fields will provide a fool-proof primary key. However, I can't get Access to use Autonumber when I'm importing records from a CSV file. Either I'm doing something wrong or autonumber was never desgined...- trident22
- Thread
- Replies: 1
- Forum: Microsoft: Office
-
Vlookup from Excel to Access
Yes you can. Create a named range in your Excel file which includes the cells whose value you query will be based on. Then create a new linked table in Access which is linked to this named range. Then, in Access, create a new query to retrieve the data you require (ie SELECT NAME, ADDRESS...- trident22
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
LOOKUP on mutiple columns
Hi, In Excel 2002 what formula(s) can I use to return a figure from the third column based on both a date in the 1st column and a code in the 2nd column. In SQL it would be approx. SELECT quant FROM xxx WHERE (vdate=dateVar And code=codeVar). Mant thanks, Al 06/03/2004 0 06/03/2004 MG 11...- trident22
- Thread
- Replies: 1
- Forum: Microsoft: Office
